Overview
Brought to you by YData
Dataset statistics
| Number of variables | 41 |
|---|---|
| Number of observations | 79542 |
| Missing cells | 467279 |
| Missing cells (%) | 14.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 24.9 MiB |
| Average record size in memory | 328.0 B |
Variable types
| Numeric | 18 |
|---|---|
| Text | 12 |
| Categorical | 10 |
| Unsupported | 1 |
RUNDATE has constant value "45401.0" | Constant |
ACQDATE is highly overall correlated with MAINOFF | High correlation |
CBSA_DIV is highly overall correlated with CBSA_DIV_FLG and 13 other fields | High correlation |
CBSA_DIV_FLG is highly overall correlated with CBSA_DIV and 3 other fields | High correlation |
CBSA_DIV_NO is highly overall correlated with CBSA_DIV and 8 other fields | High correlation |
CBSA_METRO is highly overall correlated with CBSA_DIV and 6 other fields | High correlation |
CBSA_METRO_FLG is highly overall correlated with CBSA_DIV and 6 other fields | High correlation |
CBSA_MICRO_FLG is highly overall correlated with CBSA_DIV and 1 other fields | High correlation |
CBSA_NO is highly overall correlated with CBSA_DIV and 5 other fields | High correlation |
CERT is highly overall correlated with FI_UNINUM | High correlation |
CSA_FLG is highly overall correlated with CBSA_DIV and 6 other fields | High correlation |
CSA_NO is highly overall correlated with CBSA_DIV and 6 other fields | High correlation |
FI_UNINUM is highly overall correlated with CERT | High correlation |
ID is highly overall correlated with UNINUM | High correlation |
LATITUDE is highly overall correlated with CBSA_DIV and 1 other fields | High correlation |
LONGITUDE is highly overall correlated with CBSA_DIV and 2 other fields | High correlation |
MAINOFF is highly overall correlated with ACQDATE | High correlation |
MDI_STATUS_DESC is highly overall correlated with OFFNUM | High correlation |
OFFNUM is highly overall correlated with MDI_STATUS_DESC | High correlation |
SERVTYPE is highly overall correlated with SERVTYPE_DESC | High correlation |
SERVTYPE_DESC is highly overall correlated with SERVTYPE | High correlation |
STCNTY is highly overall correlated with CBSA_DIV and 3 other fields | High correlation |
UNINUM is highly overall correlated with ID | High correlation |
X is highly overall correlated with CBSA_DIV and 2 other fields | High correlation |
Y is highly overall correlated with CBSA_DIV and 1 other fields | High correlation |
ZIP is highly overall correlated with CBSA_DIV and 2 other fields | High correlation |
CBSA_MICRO_FLG is highly imbalanced (52.8%) | Imbalance |
MAINOFF is highly imbalanced (68.2%) | Imbalance |
SERVTYPE_DESC is highly imbalanced (84.0%) | Imbalance |
ACQDATE has 35323 (44.4%) missing values | Missing |
ADDRESS2 has 74814 (94.1%) missing values | Missing |
CBSA has 20151 (25.3%) missing values | Missing |
CBSA_DIV has 64418 (81.0%) missing values | Missing |
CBSA_DIV_NO has 44268 (55.7%) missing values | Missing |
CBSA_METRO_NAME has 28187 (35.4%) missing values | Missing |
CSA has 31357 (39.4%) missing values | Missing |
CSA_NO has 11207 (14.1%) missing values | Missing |
MDI_STATUS_CODE has 77963 (98.0%) missing values | Missing |
MDI_STATUS_DESC has 77963 (98.0%) missing values | Missing |
STALP has 803 (1.0%) missing values | Missing |
STNAME has 803 (1.0%) missing values | Missing |
OBJECTID is uniformly distributed | Uniform |
OBJECTID has unique values | Unique |
MDI_STATUS_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
X has 5766 (7.2%) zeros | Zeros |
Y has 5766 (7.2%) zeros | Zeros |
CBSA_DIV_NO has 20151 (25.3%) zeros | Zeros |
CBSA_METRO has 28187 (35.4%) zeros | Zeros |
CBSA_NO has 20151 (25.3%) zeros | Zeros |
CSA_NO has 20151 (25.3%) zeros | Zeros |
LATITUDE has 5766 (7.2%) zeros | Zeros |
LONGITUDE has 5766 (7.2%) zeros | Zeros |
OFFNUM has 4577 (5.8%) zeros | Zeros |
STCNTY has 803 (1.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-06-03 16:10:50.070850 |
|---|---|
| Analysis finished | 2025-06-03 16:11:53.761757 |
| Duration | 1 minute and 3.69 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
X
Real number (ℝ)
High correlation  Zeros 
| Distinct | 72672 |
|---|---|
| Distinct (%) | 91.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -83.77563 |
| Minimum | -166.24856 |
|---|---|
| Maximum | 163.01083 |
| Zeros | 5766 |
| Zeros (%) | 7.2% |
| Negative | 73745 |
| Negative (%) | 92.7% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | -166.24856 |
|---|---|
| 5-th percentile | -121.1656 |
| Q1 | -95.931608 |
| median | -85.90069 |
| Q3 | -77.369721 |
| 95-th percentile | 0 |
| Maximum | 163.01083 |
| Range | 329.25939 |
| Interquartile range (IQR) | 18.561887 |
Descriptive statistics
| Standard deviation | 27.774008 |
|---|---|
| Coefficient of variation (CV) | -0.33152849 |
| Kurtosis | 5.2581445 |
| Mean | -83.77563 |
| Median Absolute Deviation (MAD) | 9.340965 |
| Skewness | 1.8487707 |
| Sum | -6663597.4 |
| Variance | 771.39555 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5766 | 7.2% |
| -92.296582 | 11 | < 0.1% |
| -112.0348945 | 9 | < 0.1% |
| -66.059463 | 8 | < 0.1% |
| -66.028075 | 8 | < 0.1% |
| -93.27205096 | 6 | < 0.1% |
| -98.495664 | 6 | < 0.1% |
| -66.625687 | 6 | < 0.1% |
| -96.80482098 | 6 | < 0.1% |
| -85.49964299 | 5 | < 0.1% |
| Other values (72662) | 73710 |
| Value | Count | Frequency (%) |
| -166.2485582 | 1 | |
| -165.4092107 | 1 | |
| -165.4082716 | 1 | |
| -162.592615 | 1 | |
| -161.759877 | 1 | |
| -161.7517956 | 1 | |
| -159.72357 | 1 | |
| -159.585582 | 1 | |
| -159.476557 | 1 | |
| -159.4735174 | 1 |
| Value | Count | Frequency (%) |
| 163.01083 | 1 | |
| 158.2056 | 2 | |
| 151.84316 | 1 | |
| 151.84113 | 1 | |
| 145.760035 | 1 | |
| 145.7188384 | 2 | |
| 145.7172201 | 1 | |
| 145.6210308 | 1 | |
| 145.227823 | 1 | |
| 144.8843036 | 1 |
Y
Real number (ℝ)
High correlation  Zeros 
| Distinct | 72636 |
|---|---|
| Distinct (%) | 91.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.080901 |
| Minimum | -24.892786 |
|---|---|
| Maximum | 71.293282 |
| Zeros | 5766 |
| Zeros (%) | 7.2% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | -24.892786 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 33.442709 |
| median | 38.3252 |
| Q3 | 41.248136 |
| 95-th percentile | 44.986226 |
| Maximum | 71.293282 |
| Range | 96.186068 |
| Interquartile range (IQR) | 7.8054265 |
Descriptive statistics
| Standard deviation | 11.030896 |
|---|---|
| Coefficient of variation (CV) | 0.31444165 |
| Kurtosis | 4.6456093 |
| Mean | 35.080901 |
| Median Absolute Deviation (MAD) | 3.797494 |
| Skewness | -2.2118584 |
| Sum | 2790369.9 |
| Variance | 121.68068 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5766 | 7.2% |
| 38.97345401 | 11 | < 0.1% |
| 33.50985786 | 9 | < 0.1% |
| 18.347484 | 8 | < 0.1% |
| 18.210621 | 8 | < 0.1% |
| 29.42687902 | 6 | < 0.1% |
| 32.86271798 | 6 | < 0.1% |
| 44.97609999 | 6 | < 0.1% |
| 18.103866 | 6 | < 0.1% |
| 43.08686201 | 5 | < 0.1% |
| Other values (72626) | 73710 |
| Value | Count | Frequency (%) |
| -24.89278582 | 1 | < 0.1% |
| 0 | 5766 | |
| 5.32492 | 1 | < 0.1% |
| 6.964 | 2 | < 0.1% |
| 7.34391 | 1 | < 0.1% |
| 7.34449 | 1 | < 0.1% |
| 7.44369 | 1 | < 0.1% |
| 7.44413 | 1 | < 0.1% |
| 13.39932359 | 1 | < 0.1% |
| 13.4378134 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 71.293282 | 1 | |
| 66.892278 | 1 | |
| 66.56444 | 1 | |
| 64.85844899 | 1 | |
| 64.85833001 | 1 | |
| 64.855525 | 1 | |
| 64.85161401 | 1 | |
| 64.85093201 | 1 | |
| 64.848722 | 1 | |
| 64.846762 | 1 |
OBJECTID
Real number (ℝ)
Uniform  Unique 
| Distinct | 79542 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39771.5 |
| Minimum | 1 |
|---|---|
| Maximum | 79542 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3978.05 |
| Q1 | 19886.25 |
| median | 39771.5 |
| Q3 | 59656.75 |
| 95-th percentile | 75564.95 |
| Maximum | 79542 |
| Range | 79541 |
| Interquartile range (IQR) | 39770.5 |
Descriptive statistics
| Standard deviation | 22961.942 |
|---|---|
| Coefficient of variation (CV) | 0.57734664 |
| Kurtosis | -1.2 |
| Mean | 39771.5 |
| Median Absolute Deviation (MAD) | 19885.5 |
| Skewness | 0 |
| Sum | 3.1635047 × 109 |
| Variance | 5.2725078 × 108 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 79542 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 79526 | 1 | < 0.1% |
| 79525 | 1 | < 0.1% |
| 79524 | 1 | < 0.1% |
| 79523 | 1 | < 0.1% |
| Other values (79532) | 79532 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 79542 | 1 | |
| 79541 | 1 | |
| 79540 | 1 | |
| 79539 | 1 | |
| 79538 | 1 | |
| 79537 | 1 | |
| 79536 | 1 | |
| 79535 | 1 | |
| 79534 | 1 | |
| 79533 | 1 |
ACQDATE
Real number (ℝ)
High correlation  Missing 
| Distinct | 3688 |
|---|---|
| Distinct (%) | 8.3% |
| Missing | 35323 |
| Missing (%) | 44.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39808.9 |
| Minimum | 25658 |
|---|---|
| Maximum | 45383 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 25658 |
|---|---|
| 5-th percentile | 33798 |
| Q1 | 37520.5 |
| median | 40039 |
| Q3 | 42651 |
| 95-th percentile | 44658 |
| Maximum | 45383 |
| Range | 19725 |
| Interquartile range (IQR) | 5130.5 |
Descriptive statistics
| Standard deviation | 3412.5757 |
|---|---|
| Coefficient of variation (CV) | 0.085723937 |
| Kurtosis | -0.051323007 |
| Mean | 39808.9 |
| Median Absolute Deviation (MAD) | 2604 |
| Skewness | -0.45438499 |
| Sum | 1.7603098 × 109 |
| Variance | 11645673 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40257 | 2063 | 2.6% |
| 36364 | 1127 | 1.4% |
| 38304 | 1123 | 1.4% |
| 39716 | 1115 | 1.4% |
| 40123 | 763 | 1.0% |
| 38516 | 759 | 1.0% |
| 43806 | 745 | 0.9% |
| 37112 | 646 | 0.8% |
| 40086 | 632 | 0.8% |
| 44477 | 539 | 0.7% |
| Other values (3678) | 34707 | |
| (Missing) | 35323 |
| Value | Count | Frequency (%) |
| 25658 | 1 | < 0.1% |
| 25717 | 1 | < 0.1% |
| 25720 | 2 | |
| 25750 | 4 | |
| 25837 | 1 | < 0.1% |
| 25841 | 3 | |
| 25903 | 1 | < 0.1% |
| 25937 | 2 | |
| 25980 | 1 | < 0.1% |
| 26039 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 45383 | 67 | |
| 45370 | 5 | < 0.1% |
| 45352 | 14 | < 0.1% |
| 45344 | 1 | < 0.1% |
| 45339 | 6 | < 0.1% |
| 45338 | 7 | < 0.1% |
| 45334 | 2 | < 0.1% |
| 45332 | 8 | < 0.1% |
| 45331 | 4 | < 0.1% |
| 45324 | 2 | < 0.1% |
ADDRESS
Text
| Distinct | 74294 |
|---|---|
| Distinct (%) | 93.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 73 |
|---|---|
| Median length | 65 |
| Mean length | 16.664089 |
| Min length | 3 |
Unique
| Unique | 71617 ? |
|---|---|
| Unique (%) | 90.0% |
Sample
| 1st row | 18001 Saint Rose Rd |
|---|---|
| 2nd row | 1350 12th St |
| 3rd row | 500 W Harrison St |
| 4th row | 891 Fairfax St |
| 5th row | 240 Salt Lick Rd |
| Value | Count | Frequency (%) |
| st | 24493 | 8.4% |
| ave | 12833 | 4.4% |
| rd | 12463 | 4.3% |
| n | 8040 | 2.8% |
| w | 7978 | 2.7% |
| s | 7933 | 2.7% |
| main | 7559 | 2.6% |
| e | 7123 | 2.4% |
| blvd | 6243 | 2.1% |
| dr | 4518 | 1.5% |
| Other values (24052) | 192899 |
Most occurring characters
| Value | Count | Frequency (%) |
| 212625 | 16.0% | |
| e | 72758 | 5.5% |
| t | 63820 | 4.8% |
| 1 | 60682 | 4.6% |
| a | 59845 | 4.5% |
| 0 | 55690 | 4.2% |
| n | 47693 | 3.6% |
| r | 45183 | 3.4% |
| S | 43994 | 3.3% |
| i | 41606 | 3.1% |
| Other values (65) | 621599 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1325495 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 212625 | 16.0% | |
| e | 72758 | 5.5% |
| t | 63820 | 4.8% |
| 1 | 60682 | 4.6% |
| a | 59845 | 4.5% |
| 0 | 55690 | 4.2% |
| n | 47693 | 3.6% |
| r | 45183 | 3.4% |
| S | 43994 | 3.3% |
| i | 41606 | 3.1% |
| Other values (65) | 621599 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1325495 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 212625 | 16.0% | |
| e | 72758 | 5.5% |
| t | 63820 | 4.8% |
| 1 | 60682 | 4.6% |
| a | 59845 | 4.5% |
| 0 | 55690 | 4.2% |
| n | 47693 | 3.6% |
| r | 45183 | 3.4% |
| S | 43994 | 3.3% |
| i | 41606 | 3.1% |
| Other values (65) | 621599 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1325495 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 212625 | 16.0% | |
| e | 72758 | 5.5% |
| t | 63820 | 4.8% |
| 1 | 60682 | 4.6% |
| a | 59845 | 4.5% |
| 0 | 55690 | 4.2% |
| n | 47693 | 3.6% |
| r | 45183 | 3.4% |
| S | 43994 | 3.3% |
| i | 41606 | 3.1% |
| Other values (65) | 621599 |
ADDRESS2
Text
Missing 
| Distinct | 1302 |
|---|---|
| Distinct (%) | 27.5% |
| Missing | 74814 |
| Missing (%) | 94.1% |
| Memory size | 621.6 KiB |
Length
| Max length | 51 |
|---|---|
| Median length | 7 |
| Mean length | 7.4426819 |
| Min length | 1 |
Unique
| Unique | 979 ? |
|---|---|
| Unique (%) | 20.7% |
Sample
| 1st row | Ste 104 |
|---|---|
| 2nd row | Ste 150 |
| 3rd row | Ste 300 |
| 4th row | Ste D |
| 5th row | Ste 105 |
| Value | Count | Frequency (%) |
| ste | 3691 | |
| 100 | 858 | 8.7% |
| 101 | 275 | 2.8% |
| suite | 262 | 2.6% |
| a | 260 | 2.6% |
| 223 | 2.3% | |
| 200 | 135 | 1.4% |
| unit | 131 | 1.3% |
| 1 | 127 | 1.3% |
| 150 | 108 | 1.1% |
| Other values (1143) | 3832 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5180 | ||
| 0 | 4420 | |
| t | 4343 | |
| e | 4331 | |
| S | 4064 | |
| 1 | 3452 | |
| 2 | 1036 | 2.9% |
| 5 | 653 | 1.9% |
| i | 604 | 1.7% |
| 3 | 530 | 1.5% |
| Other values (62) | 6576 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 35189 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5180 | ||
| 0 | 4420 | |
| t | 4343 | |
| e | 4331 | |
| S | 4064 | |
| 1 | 3452 | |
| 2 | 1036 | 2.9% |
| 5 | 653 | 1.9% |
| i | 604 | 1.7% |
| 3 | 530 | 1.5% |
| Other values (62) | 6576 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 35189 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5180 | ||
| 0 | 4420 | |
| t | 4343 | |
| e | 4331 | |
| S | 4064 | |
| 1 | 3452 | |
| 2 | 1036 | 2.9% |
| 5 | 653 | 1.9% |
| i | 604 | 1.7% |
| 3 | 530 | 1.5% |
| Other values (62) | 6576 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 35189 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5180 | ||
| 0 | 4420 | |
| t | 4343 | |
| e | 4331 | |
| S | 4064 | |
| 1 | 3452 | |
| 2 | 1036 | 2.9% |
| 5 | 653 | 1.9% |
| i | 604 | 1.7% |
| 3 | 530 | 1.5% |
| Other values (62) | 6576 |
BKCLASS
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
| N | |
|---|---|
| NM | |
| SM | |
| SI | 2446 |
| SB | 1842 |
| Other values (3) | 157 |
Length
| Max length | 7 |
|---|---|
| Median length | 2 |
| Mean length | 1.5379548 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SM |
|---|---|
| 2nd row | SM |
| 3rd row | SM |
| 4th row | SM |
| 5th row | NM |
Common Values
| Value | Count | Frequency (%) |
| N | 36757 | |
| NM | 25032 | |
| SM | 13308 | 16.7% |
| SI | 2446 | 3.1% |
| SB | 1842 | 2.3% |
| SL | 146 | 0.2% |
| OI | 10 | < 0.1% |
| BKCLASS | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| n | 36757 | |
| nm | 25032 | |
| sm | 13308 | 16.7% |
| si | 2446 | 3.1% |
| sb | 1842 | 2.3% |
| sl | 146 | 0.2% |
| oi | 10 | < 0.1% |
| bkclass | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 61789 | |
| M | 38340 | |
| S | 17744 | 14.5% |
| I | 2456 | 2.0% |
| B | 1843 | 1.5% |
| L | 147 | 0.1% |
| O | 10 | < 0.1% |
| K | 1 | < 0.1% |
| C | 1 | < 0.1% |
| A | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 122332 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 61789 | |
| M | 38340 | |
| S | 17744 | 14.5% |
| I | 2456 | 2.0% |
| B | 1843 | 1.5% |
| L | 147 | 0.1% |
| O | 10 | < 0.1% |
| K | 1 | < 0.1% |
| C | 1 | < 0.1% |
| A | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 122332 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 61789 | |
| M | 38340 | |
| S | 17744 | 14.5% |
| I | 2456 | 2.0% |
| B | 1843 | 1.5% |
| L | 147 | 0.1% |
| O | 10 | < 0.1% |
| K | 1 | < 0.1% |
| C | 1 | < 0.1% |
| A | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 122332 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 61789 | |
| M | 38340 | |
| S | 17744 | 14.5% |
| I | 2456 | 2.0% |
| B | 1843 | 1.5% |
| L | 147 | 0.1% |
| O | 10 | < 0.1% |
| K | 1 | < 0.1% |
| C | 1 | < 0.1% |
| A | 1 | < 0.1% |
CBSA
Text
Missing 
| Distinct | 823 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 20151 |
| Missing (%) | 25.3% |
| Memory size | 621.6 KiB |
Length
| Max length | 45 |
|---|---|
| Median length | 34 |
| Mean length | 24.396255 |
| Min length | 4 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | St. Louis, MO-IL |
|---|---|
| 2nd row | St. Louis, MO-IL |
| 3rd row | St. Louis, MO-IL |
| 4th row | St. Louis, MO-IL |
| 5th row | St. Louis, MO-IL |
| Value | Count | Frequency (%) |
| city | 6526 | 4.3% |
| tx | 5732 | 3.8% |
| new | 4694 | 3.1% |
| york-newark-jersey | 4299 | 2.8% |
| ny-nj-pa | 4299 | 2.8% |
| fl | 4287 | 2.8% |
| oh | 2334 | 1.5% |
| il-in-wi | 2252 | 1.5% |
| chicago-naperville-elgin | 2252 | 1.5% |
| pa | 2151 | 1.4% |
| Other values (922) | 113084 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 94130 | 6.5% |
| - | 92785 | 6.4% |
| 92519 | 6.4% | |
| e | 91360 | 6.3% |
| o | 78746 | 5.4% |
| n | 76660 | 5.3% |
| r | 71410 | 4.9% |
| i | 65973 | 4.6% |
| l | 61528 | 4.2% |
| , | 59390 | 4.1% |
| Other values (47) | 664417 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1448918 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 94130 | 6.5% |
| - | 92785 | 6.4% |
| 92519 | 6.4% | |
| e | 91360 | 6.3% |
| o | 78746 | 5.4% |
| n | 76660 | 5.3% |
| r | 71410 | 4.9% |
| i | 65973 | 4.6% |
| l | 61528 | 4.2% |
| , | 59390 | 4.1% |
| Other values (47) | 664417 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1448918 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 94130 | 6.5% |
| - | 92785 | 6.4% |
| 92519 | 6.4% | |
| e | 91360 | 6.3% |
| o | 78746 | 5.4% |
| n | 76660 | 5.3% |
| r | 71410 | 4.9% |
| i | 65973 | 4.6% |
| l | 61528 | 4.2% |
| , | 59390 | 4.1% |
| Other values (47) | 664417 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1448918 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 94130 | 6.5% |
| - | 92785 | 6.4% |
| 92519 | 6.4% | |
| e | 91360 | 6.3% |
| o | 78746 | 5.4% |
| n | 76660 | 5.3% |
| r | 71410 | 4.9% |
| i | 65973 | 4.6% |
| l | 61528 | 4.2% |
| , | 59390 | 4.1% |
| Other values (47) | 664417 |
CBSA_DIV
Categorical
High correlation  Missing 
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 64418 |
| Missing (%) | 81.0% |
| Memory size | 621.6 KiB |
| New York-Jersey City-White Plains, NY-NJ | |
|---|---|
| Chicago-Naperville-Evanston, IL | |
| Dallas-Plano-Irving, TX | |
| Washington-Arlington-Alexandria, DC-VA-MD-WV | |
| Cambridge-Newton-Framingham, MA | 694 |
| Other values (22) |
Length
| Max length | 49 |
|---|---|
| Median length | 38 |
| Mean length | 30.63343 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Camden, NJ |
|---|---|
| 2nd row | Camden, NJ |
| 3rd row | Montgomery County-Bucks County-Chester County, PA |
| 4th row | Camden, NJ |
| 5th row | Chicago-Naperville-Evanston, IL |
Common Values
| Value | Count | Frequency (%) |
| New York-Jersey City-White Plains, NY-NJ | 2392 | 3.0% |
| Chicago-Naperville-Evanston, IL | 1679 | 2.1% |
| Dallas-Plano-Irving, TX | 1129 | 1.4% |
| Washington-Arlington-Alexandria, DC-VA-MD-WV | 951 | 1.2% |
| Cambridge-Newton-Framingham, MA | 694 | 0.9% |
| Nassau County-Suffolk County, NY | 657 | 0.8% |
| New Brunswick-Lakewood, NJ | 648 | 0.8% |
| Seattle-Bellevue-Kent, WA | 613 | 0.8% |
| Newark, NJ-PA | 602 | 0.8% |
| Montgomery County-Bucks County-Chester County, PA | 586 | 0.7% |
| Other values (17) | 5173 | 6.5% |
| (Missing) | 64418 |
Length
| Value | Count | Frequency (%) |
| new | 3040 | 6.6% |
| york-jersey | 2392 | 5.2% |
| city-white | 2392 | 5.2% |
| plains | 2392 | 5.2% |
| ny-nj | 2392 | 5.2% |
| il | 1863 | 4.1% |
| chicago-naperville-evanston | 1679 | 3.7% |
| tx | 1646 | 3.6% |
| county | 1555 | 3.4% |
| fl | 1350 | 3.0% |
| Other values (51) | 25026 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 30816 | 6.7% |
| 30603 | 6.6% | |
| - | 30147 | 6.5% |
| a | 29318 | 6.3% |
| n | 27591 | 6.0% |
| o | 24817 | 5.4% |
| i | 24424 | 5.3% |
| t | 21093 | 4.6% |
| r | 20954 | 4.5% |
| l | 18764 | 4.1% |
| Other values (39) | 204773 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 463300 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 30816 | 6.7% |
| 30603 | 6.6% | |
| - | 30147 | 6.5% |
| a | 29318 | 6.3% |
| n | 27591 | 6.0% |
| o | 24817 | 5.4% |
| i | 24424 | 5.3% |
| t | 21093 | 4.6% |
| r | 20954 | 4.5% |
| l | 18764 | 4.1% |
| Other values (39) | 204773 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 463300 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 30816 | 6.7% |
| 30603 | 6.6% | |
| - | 30147 | 6.5% |
| a | 29318 | 6.3% |
| n | 27591 | 6.0% |
| o | 24817 | 5.4% |
| i | 24424 | 5.3% |
| t | 21093 | 4.6% |
| r | 20954 | 4.5% |
| l | 18764 | 4.1% |
| Other values (39) | 204773 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 463300 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 30816 | 6.7% |
| 30603 | 6.6% | |
| - | 30147 | 6.5% |
| a | 29318 | 6.3% |
| n | 27591 | 6.0% |
| o | 24817 | 5.4% |
| i | 24424 | 5.3% |
| t | 21093 | 4.6% |
| r | 20954 | 4.5% |
| l | 18764 | 4.1% |
| Other values (39) | 204773 |
CBSA_DIV_FLG
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 621.6 KiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 64418 | |
| 1.0 | 15123 | 19.0% |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 64418 | |
| 1.0 | 15123 | 19.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 143959 | |
| . | 79541 | |
| 1 | 15123 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 143959 | |
| . | 79541 | |
| 1 | 15123 | 6.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 143959 | |
| . | 79541 | |
| 1 | 15123 | 6.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 143959 | |
| . | 79541 | |
| 1 | 15123 | 6.3% |
CBSA_DIV_NO
Real number (ℝ)
High correlation  Missing  Zeros 
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 44268 |
| Missing (%) | 55.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13093.458 |
| Minimum | 0 |
|---|---|
| Maximum | 48864 |
| Zeros | 20151 |
| Zeros (%) | 25.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 29404 |
| 95-th percentile | 47664 |
| Maximum | 48864 |
| Range | 48864 |
| Interquartile range (IQR) | 29404 |
Descriptive statistics
| Standard deviation | 16743.616 |
|---|---|
| Coefficient of variation (CV) | 1.2787772 |
| Kurtosis | -0.90882396 |
| Mean | 13093.458 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.79692815 |
| Sum | 4.6185865 × 108 |
| Variance | 2.8034868 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20151 | |
| 35614 | 2392 | 3.0% |
| 16984 | 1679 | 2.1% |
| 19124 | 1129 | 1.4% |
| 47894 | 951 | 1.2% |
| 15764 | 694 | 0.9% |
| 35004 | 657 | 0.8% |
| 35154 | 648 | 0.8% |
| 42644 | 613 | 0.8% |
| 35084 | 602 | 0.8% |
| Other values (17) | 5758 | 7.2% |
| (Missing) | 44268 |
| Value | Count | Frequency (%) |
| 0 | 20151 | |
| 14454 | 575 | 0.7% |
| 15764 | 694 | 0.9% |
| 15804 | 262 | 0.3% |
| 16984 | 1679 | 2.1% |
| 19124 | 1129 | 1.4% |
| 19804 | 252 | 0.3% |
| 20994 | 184 | 0.2% |
| 22744 | 373 | 0.5% |
| 23104 | 517 | 0.6% |
| Value | Count | Frequency (%) |
| 48864 | 199 | 0.3% |
| 48424 | 396 | 0.5% |
| 47894 | 951 | 1.2% |
| 47664 | 532 | 0.7% |
| 45104 | 127 | 0.2% |
| 42644 | 613 | 0.8% |
| 40484 | 118 | 0.1% |
| 37964 | 380 | 0.5% |
| 35614 | 2392 | |
| 35154 | 648 | 0.8% |
CBSA_METRO
Real number (ℝ)
High correlation  Zeros 
| Distinct | 330 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19092.77 |
| Minimum | 0 |
|---|---|
| Maximum | 49660 |
| Zeros | 28187 |
| Zeros (%) | 35.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 17460 |
| Q3 | 35620 |
| 95-th percentile | 45500 |
| Maximum | 49660 |
| Range | 49660 |
| Interquartile range (IQR) | 35620 |
Descriptive statistics
| Standard deviation | 16729.762 |
|---|---|
| Coefficient of variation (CV) | 0.87623546 |
| Kurtosis | -1.4394915 |
| Mean | 19092.77 |
| Median Absolute Deviation (MAD) | 17460 |
| Skewness | 0.15337292 |
| Sum | 1.518658 × 109 |
| Variance | 2.7988494 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 28187 | |
| 35620 | 4299 | 5.4% |
| 16980 | 2252 | 2.8% |
| 19100 | 1646 | 2.1% |
| 37980 | 1427 | 1.8% |
| 14460 | 1387 | 1.7% |
| 26420 | 1360 | 1.7% |
| 33100 | 1350 | 1.7% |
| 47900 | 1238 | 1.6% |
| 12060 | 1071 | 1.3% |
| Other values (320) | 35324 |
| Value | Count | Frequency (%) |
| 0 | 28187 | |
| 10180 | 47 | 0.1% |
| 10380 | 15 | < 0.1% |
| 10420 | 165 | 0.2% |
| 10500 | 37 | < 0.1% |
| 10540 | 20 | < 0.1% |
| 10580 | 272 | 0.3% |
| 10740 | 138 | 0.2% |
| 10780 | 59 | 0.1% |
| 10900 | 194 | 0.2% |
| Value | Count | Frequency (%) |
| 49660 | 117 | |
| 49620 | 102 | |
| 49500 | 7 | < 0.1% |
| 49420 | 39 | < 0.1% |
| 49340 | 196 | |
| 49180 | 128 | |
| 49020 | 45 | 0.1% |
| 48900 | 58 | 0.1% |
| 48700 | 46 | 0.1% |
| 48660 | 38 | < 0.1% |
CBSA_METRO_FLG
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 621.6 KiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 51354 | |
| 0.0 | 28187 | |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 51354 | |
| 0.0 | 28187 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 107728 | |
| . | 79541 | |
| 1 | 51354 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 107728 | |
| . | 79541 | |
| 1 | 51354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 107728 | |
| . | 79541 | |
| 1 | 51354 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 107728 | |
| . | 79541 | |
| 1 | 51354 |
CBSA_METRO_NAME
Text
Missing 
| Distinct | 330 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 28187 |
| Missing (%) | 35.4% |
| Memory size | 621.6 KiB |
Length
| Max length | 45 |
|---|---|
| Median length | 33 |
| Mean length | 26.136579 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | St. Louis, MO-IL |
|---|---|
| 2nd row | St. Louis, MO-IL |
| 3rd row | St. Louis, MO-IL |
| 4th row | St. Louis, MO-IL |
| 5th row | St. Louis, MO-IL |
| Value | Count | Frequency (%) |
| city | 6268 | 4.7% |
| tx | 5237 | 3.9% |
| new | 4619 | 3.4% |
| york-newark-jersey | 4299 | 3.2% |
| ny-nj-pa | 4299 | 3.2% |
| fl | 4213 | 3.1% |
| il-in-wi | 2252 | 1.7% |
| chicago-naperville-elgin | 2252 | 1.7% |
| pa | 1815 | 1.4% |
| oh | 1734 | 1.3% |
| Other values (460) | 97386 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 91806 | 6.8% |
| a | 88095 | 6.6% |
| e | 84320 | 6.3% |
| 83019 | 6.2% | |
| o | 73512 | 5.5% |
| n | 70904 | 5.3% |
| r | 66684 | 5.0% |
| i | 61287 | 4.6% |
| l | 56478 | 4.2% |
| t | 54828 | 4.1% |
| Other values (45) | 611311 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1342244 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 91806 | 6.8% |
| a | 88095 | 6.6% |
| e | 84320 | 6.3% |
| 83019 | 6.2% | |
| o | 73512 | 5.5% |
| n | 70904 | 5.3% |
| r | 66684 | 5.0% |
| i | 61287 | 4.6% |
| l | 56478 | 4.2% |
| t | 54828 | 4.1% |
| Other values (45) | 611311 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1342244 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 91806 | 6.8% |
| a | 88095 | 6.6% |
| e | 84320 | 6.3% |
| 83019 | 6.2% | |
| o | 73512 | 5.5% |
| n | 70904 | 5.3% |
| r | 66684 | 5.0% |
| i | 61287 | 4.6% |
| l | 56478 | 4.2% |
| t | 54828 | 4.1% |
| Other values (45) | 611311 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1342244 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 91806 | 6.8% |
| a | 88095 | 6.6% |
| e | 84320 | 6.3% |
| 83019 | 6.2% | |
| o | 73512 | 5.5% |
| n | 70904 | 5.3% |
| r | 66684 | 5.0% |
| i | 61287 | 4.6% |
| l | 56478 | 4.2% |
| t | 54828 | 4.1% |
| Other values (45) | 611311 |
CBSA_MICRO_FLG
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 621.6 KiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 71505 | |
| 1.0 | 8036 | 10.1% |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 71505 | |
| 1.0 | 8036 | 10.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 151046 | |
| . | 79541 | |
| 1 | 8036 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 151046 | |
| . | 79541 | |
| 1 | 8036 | 3.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 151046 | |
| . | 79541 | |
| 1 | 8036 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 151046 | |
| . | 79541 | |
| 1 | 8036 | 3.4% |
CBSA_NO
Real number (ℝ)
High correlation  Zeros 
| Distinct | 823 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22142.574 |
| Minimum | 0 |
|---|---|
| Maximum | 49820 |
| Zeros | 20151 |
| Zeros (%) | 25.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 22800 |
| Q3 | 35620 |
| 95-th percentile | 46140 |
| Maximum | 49820 |
| Range | 49820 |
| Interquartile range (IQR) | 35620 |
Descriptive statistics
| Standard deviation | 16085.458 |
|---|---|
| Coefficient of variation (CV) | 0.72644931 |
| Kurtosis | -1.3133933 |
| Mean | 22142.574 |
| Median Absolute Deviation (MAD) | 12820 |
| Skewness | -0.1023125 |
| Sum | 1.7612425 × 109 |
| Variance | 2.5874196 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20151 | |
| 35620 | 4299 | 5.4% |
| 16980 | 2252 | 2.8% |
| 19100 | 1646 | 2.1% |
| 37980 | 1427 | 1.8% |
| 14460 | 1387 | 1.7% |
| 26420 | 1360 | 1.7% |
| 33100 | 1350 | 1.7% |
| 47900 | 1238 | 1.6% |
| 12060 | 1071 | 1.3% |
| Other values (813) | 43360 |
| Value | Count | Frequency (%) |
| 0 | 20151 | |
| 10100 | 20 | < 0.1% |
| 10140 | 23 | < 0.1% |
| 10180 | 47 | 0.1% |
| 10220 | 15 | < 0.1% |
| 10300 | 18 | < 0.1% |
| 10380 | 15 | < 0.1% |
| 10420 | 165 | 0.2% |
| 10460 | 13 | < 0.1% |
| 10500 | 37 | < 0.1% |
| Value | Count | Frequency (%) |
| 49820 | 3 | < 0.1% |
| 49780 | 27 | < 0.1% |
| 49660 | 117 | |
| 49620 | 102 | |
| 49500 | 7 | < 0.1% |
| 49460 | 9 | < 0.1% |
| 49420 | 39 | < 0.1% |
| 49380 | 13 | < 0.1% |
| 49340 | 196 | |
| 49300 | 43 | 0.1% |
CERT
Real number (ℝ)
High correlation 
| Distinct | 4577 |
|---|---|
| Distinct (%) | 5.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14436.781 |
| Minimum | 14 |
|---|---|
| Maximum | 91325 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 14 |
|---|---|
| 5-th percentile | 628 |
| Q1 | 3511 |
| median | 9712 |
| Q3 | 18609 |
| 95-th percentile | 57415 |
| Maximum | 91325 |
| Range | 91311 |
| Interquartile range (IQR) | 15098 |
Descriptive statistics
| Standard deviation | 14942.208 |
|---|---|
| Coefficient of variation (CV) | 1.0350097 |
| Kurtosis | 4.600371 |
| Mean | 14436.781 |
| Median Absolute Deviation (MAD) | 6427 |
| Skewness | 1.9460052 |
| Sum | 1.148316 × 109 |
| Variance | 2.2326958 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 628 | 5141 | 6.5% |
| 3511 | 4366 | 5.5% |
| 3510 | 3977 | 5.0% |
| 6384 | 2375 | 3.0% |
| 6548 | 2299 | 2.9% |
| 9846 | 2005 | 2.5% |
| 12368 | 1282 | 1.6% |
| 18409 | 1184 | 1.5% |
| 6560 | 1177 | 1.5% |
| 6672 | 1079 | 1.4% |
| Other values (4567) | 54656 |
| Value | Count | Frequency (%) |
| 14 | 3 | < 0.1% |
| 35 | 8 | < 0.1% |
| 39 | 8 | < 0.1% |
| 41 | 4 | < 0.1% |
| 49 | 1 | < 0.1% |
| 50 | 7 | < 0.1% |
| 51 | 5 | < 0.1% |
| 52 | 1 | < 0.1% |
| 54 | 5 | < 0.1% |
| 58 | 21 |
| Value | Count | Frequency (%) |
| 91325 | 15 | |
| 91280 | 5 | < 0.1% |
| 91005 | 6 | < 0.1% |
| 90384 | 4 | < 0.1% |
| 90311 | 7 | < 0.1% |
| 90308 | 6 | < 0.1% |
| 90303 | 13 | |
| 90300 | 27 | |
| 90297 | 7 | < 0.1% |
| 90291 | 9 | < 0.1% |
CITY
Text
| Distinct | 10354 |
|---|---|
| Distinct (%) | 13.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 25 |
| Mean length | 8.8637324 |
| Min length | 3 |
Unique
| Unique | 3716 ? |
|---|---|
| Unique (%) | 4.7% |
Sample
| 1st row | Breese |
|---|---|
| 2nd row | Carlyle |
| 3rd row | Aviston |
| 4th row | Carlyle |
| 5th row | Saint Peters |
| Value | Count | Frequency (%) |
| city | 2141 | 2.1% |
| new | 1217 | 1.2% |
| san | 1168 | 1.2% |
| beach | 946 | 0.9% |
| park | 786 | 0.8% |
| fort | 755 | 0.7% |
| lake | 722 | 0.7% |
| york | 663 | 0.7% |
| west | 660 | 0.7% |
| saint | 643 | 0.6% |
| Other values (8480) | 91511 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 64102 | 9.1% |
| a | 60487 | 8.6% |
| o | 54155 | 7.7% |
| n | 53613 | 7.6% |
| l | 47976 | 6.8% |
| i | 44204 | 6.3% |
| r | 44143 | 6.3% |
| t | 37189 | 5.3% |
| s | 30731 | 4.4% |
| 21671 | 3.1% | |
| Other values (55) | 246768 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 705039 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 64102 | 9.1% |
| a | 60487 | 8.6% |
| o | 54155 | 7.7% |
| n | 53613 | 7.6% |
| l | 47976 | 6.8% |
| i | 44204 | 6.3% |
| r | 44143 | 6.3% |
| t | 37189 | 5.3% |
| s | 30731 | 4.4% |
| 21671 | 3.1% | |
| Other values (55) | 246768 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 705039 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 64102 | 9.1% |
| a | 60487 | 8.6% |
| o | 54155 | 7.7% |
| n | 53613 | 7.6% |
| l | 47976 | 6.8% |
| i | 44204 | 6.3% |
| r | 44143 | 6.3% |
| t | 37189 | 5.3% |
| s | 30731 | 4.4% |
| 21671 | 3.1% | |
| Other values (55) | 246768 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 705039 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 64102 | 9.1% |
| a | 60487 | 8.6% |
| o | 54155 | 7.7% |
| n | 53613 | 7.6% |
| l | 47976 | 6.8% |
| i | 44204 | 6.3% |
| r | 44143 | 6.3% |
| t | 37189 | 5.3% |
| s | 30731 | 4.4% |
| 21671 | 3.1% | |
| Other values (55) | 246768 |
COUNTY
Text
| Distinct | 1914 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 21 |
|---|---|
| Median length | 19 |
| Mean length | 7.4486058 |
| Min length | 3 |
Unique
| Unique | 135 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Clinton |
|---|---|
| 2nd row | Clinton |
| 3rd row | Clinton |
| 4th row | Clinton |
| 5th row | St. Charles |
| Value | Count | Frequency (%) |
| los | 1471 | 1.6% |
| angeles | 1466 | 1.6% |
| san | 1355 | 1.5% |
| cook | 1162 | 1.3% |
| st | 1083 | 1.2% |
| new | 1067 | 1.2% |
| orange | 977 | 1.1% |
| montgomery | 973 | 1.1% |
| jefferson | 947 | 1.0% |
| harris | 888 | 1.0% |
| Other values (1927) | 78951 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 60033 | 10.1% |
| e | 55815 | 9.4% |
| n | 46011 | 7.8% |
| o | 45147 | 7.6% |
| r | 38114 | 6.4% |
| l | 33275 | 5.6% |
| i | 32248 | 5.4% |
| s | 28551 | 4.8% |
| t | 24319 | 4.1% |
| u | 15271 | 2.6% |
| Other values (47) | 213693 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 592477 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 60033 | 10.1% |
| e | 55815 | 9.4% |
| n | 46011 | 7.8% |
| o | 45147 | 7.6% |
| r | 38114 | 6.4% |
| l | 33275 | 5.6% |
| i | 32248 | 5.4% |
| s | 28551 | 4.8% |
| t | 24319 | 4.1% |
| u | 15271 | 2.6% |
| Other values (47) | 213693 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 592477 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 60033 | 10.1% |
| e | 55815 | 9.4% |
| n | 46011 | 7.8% |
| o | 45147 | 7.6% |
| r | 38114 | 6.4% |
| l | 33275 | 5.6% |
| i | 32248 | 5.4% |
| s | 28551 | 4.8% |
| t | 24319 | 4.1% |
| u | 15271 | 2.6% |
| Other values (47) | 213693 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 592477 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 60033 | 10.1% |
| e | 55815 | 9.4% |
| n | 46011 | 7.8% |
| o | 45147 | 7.6% |
| r | 38114 | 6.4% |
| l | 33275 | 5.6% |
| i | 32248 | 5.4% |
| s | 28551 | 4.8% |
| t | 24319 | 4.1% |
| u | 15271 | 2.6% |
| Other values (47) | 213693 |
CSA
Text
Missing 
| Distinct | 155 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 31357 |
| Missing (%) | 39.4% |
| Memory size | 621.6 KiB |
Length
| Max length | 58 |
|---|---|
| Median length | 41 |
| Mean length | 31.908519 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | St. Louis-St. Charles-Farmington, MO-IL |
|---|---|
| 2nd row | St. Louis-St. Charles-Farmington, MO-IL |
| 3rd row | St. Louis-St. Charles-Farmington, MO-IL |
| 4th row | St. Louis-St. Charles-Farmington, MO-IL |
| 5th row | St. Louis-St. Charles-Farmington, MO-IL |
| Value | Count | Frequency (%) |
| new | 5058 | 3.9% |
| ny-nj-ct-pa | 4661 | 3.6% |
| york-newark | 4661 | 3.6% |
| fl | 2896 | 2.2% |
| tx | 2639 | 2.0% |
| il-in-wi | 2386 | 1.8% |
| chicago-naperville | 2386 | 1.8% |
| st | 2382 | 1.8% |
| boston-worcester-providence | 2212 | 1.7% |
| ma-ri-nh-ct | 2212 | 1.7% |
| Other values (294) | 99105 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 132236 | 8.6% |
| a | 99827 | 6.5% |
| e | 99057 | 6.4% |
| o | 84261 | 5.5% |
| n | 83220 | 5.4% |
| 82413 | 5.4% | |
| r | 76193 | 5.0% |
| i | 66479 | 4.3% |
| t | 64955 | 4.2% |
| l | 63105 | 4.1% |
| Other values (46) | 685766 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1537512 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 132236 | 8.6% |
| a | 99827 | 6.5% |
| e | 99057 | 6.4% |
| o | 84261 | 5.5% |
| n | 83220 | 5.4% |
| 82413 | 5.4% | |
| r | 76193 | 5.0% |
| i | 66479 | 4.3% |
| t | 64955 | 4.2% |
| l | 63105 | 4.1% |
| Other values (46) | 685766 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1537512 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 132236 | 8.6% |
| a | 99827 | 6.5% |
| e | 99057 | 6.4% |
| o | 84261 | 5.5% |
| n | 83220 | 5.4% |
| 82413 | 5.4% | |
| r | 76193 | 5.0% |
| i | 66479 | 4.3% |
| t | 64955 | 4.2% |
| l | 63105 | 4.1% |
| Other values (46) | 685766 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1537512 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 132236 | 8.6% |
| a | 99827 | 6.5% |
| e | 99057 | 6.4% |
| o | 84261 | 5.5% |
| n | 83220 | 5.4% |
| 82413 | 5.4% | |
| r | 76193 | 5.0% |
| i | 66479 | 4.3% |
| t | 64955 | 4.2% |
| l | 63105 | 4.1% |
| Other values (46) | 685766 |
CSA_FLG
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 621.6 KiB |
| 1.0 | |
|---|---|
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 48184 | |
| 0.0 | 31357 | |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 48184 | |
| 0.0 | 31357 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 110898 | |
| . | 79541 | |
| 1 | 48184 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 110898 | |
| . | 79541 | |
| 1 | 48184 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 110898 | |
| . | 79541 | |
| 1 | 48184 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 110898 | |
| . | 79541 | |
| 1 | 48184 |
CSA_NO
Real number (ℝ)
High correlation  Missing  Zeros 
| Distinct | 155 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 11207 |
| Missing (%) | 14.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 232.08586 |
| Minimum | 0 |
|---|---|
| Maximum | 566 |
| Zeros | 20151 |
| Zeros (%) | 25.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 212 |
| Q3 | 408 |
| 95-th percentile | 534 |
| Maximum | 566 |
| Range | 566 |
| Interquartile range (IQR) | 408 |
Descriptive statistics
| Standard deviation | 185.23903 |
|---|---|
| Coefficient of variation (CV) | 0.79814872 |
| Kurtosis | -1.3672762 |
| Mean | 232.08586 |
| Median Absolute Deviation (MAD) | 196 |
| Skewness | 0.055114421 |
| Sum | 15859587 |
| Variance | 34313.498 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20151 | |
| 408 | 4661 | 5.9% |
| 176 | 2386 | 3.0% |
| 148 | 2212 | 2.8% |
| 548 | 1965 | 2.5% |
| 206 | 1797 | 2.3% |
| 428 | 1661 | 2.1% |
| 370 | 1515 | 1.9% |
| 288 | 1407 | 1.8% |
| 122 | 1232 | 1.5% |
| Other values (145) | 29348 | |
| (Missing) | 11207 | 14.1% |
| Value | Count | Frequency (%) |
| 0 | 20151 | |
| 104 | 357 | 0.4% |
| 106 | 189 | 0.2% |
| 107 | 61 | 0.1% |
| 108 | 81 | 0.1% |
| 118 | 81 | 0.1% |
| 120 | 109 | 0.1% |
| 122 | 1232 | 1.5% |
| 140 | 50 | 0.1% |
| 144 | 49 | 0.1% |
| Value | Count | Frequency (%) |
| 566 | 149 | 0.2% |
| 558 | 58 | 0.1% |
| 556 | 236 | 0.3% |
| 554 | 102 | 0.1% |
| 548 | 1965 | |
| 545 | 272 | 0.3% |
| 544 | 34 | < 0.1% |
| 540 | 101 | 0.1% |
| 539 | 91 | 0.1% |
| 538 | 311 | 0.4% |
ESTYMD
Text
| Distinct | 26127 |
|---|---|
| Distinct (%) | 32.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.3876443 |
| Min length | 1 |
Unique
| Unique | 13497 ? |
|---|---|
| Unique (%) | 17.0% |
Sample
| 1st row | 30964 |
|---|---|
| 2nd row | 25373 |
| 3rd row | 39104 |
| 4th row | 01/01/1878 |
| 5th row | 38383 |
| Value | Count | Frequency (%) |
| 01/01/1889 | 312 | 0.4% |
| 01/01/1890 | 249 | 0.3% |
| 01/01/1934 | 233 | 0.3% |
| 01/01/1919 | 232 | 0.3% |
| 01/01/1923 | 232 | 0.3% |
| 01/01/1887 | 205 | 0.3% |
| 01/01/1921 | 159 | 0.2% |
| 10/23/1989 | 156 | 0.2% |
| 06/30/1987 | 153 | 0.2% |
| 06/30/1985 | 148 | 0.2% |
| Other values (26117) | 77463 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 152117 | |
| / | 139934 | |
| 1 | 134962 | |
| 2 | 81802 | |
| 9 | 69713 | |
| 8 | 33477 | 4.5% |
| 3 | 31566 | 4.2% |
| 7 | 27990 | 3.7% |
| 6 | 26864 | 3.6% |
| 5 | 24649 | 3.3% |
| Other values (7) | 23638 | 3.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 746712 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 152117 | |
| / | 139934 | |
| 1 | 134962 | |
| 2 | 81802 | |
| 9 | 69713 | |
| 8 | 33477 | 4.5% |
| 3 | 31566 | 4.2% |
| 7 | 27990 | 3.7% |
| 6 | 26864 | 3.6% |
| 5 | 24649 | 3.3% |
| Other values (7) | 23638 | 3.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 746712 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 152117 | |
| / | 139934 | |
| 1 | 134962 | |
| 2 | 81802 | |
| 9 | 69713 | |
| 8 | 33477 | 4.5% |
| 3 | 31566 | 4.2% |
| 7 | 27990 | 3.7% |
| 6 | 26864 | 3.6% |
| 5 | 24649 | 3.3% |
| Other values (7) | 23638 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 746712 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 152117 | |
| / | 139934 | |
| 1 | 134962 | |
| 2 | 81802 | |
| 9 | 69713 | |
| 8 | 33477 | 4.5% |
| 3 | 31566 | 4.2% |
| 7 | 27990 | 3.7% |
| 6 | 26864 | 3.6% |
| 5 | 24649 | 3.3% |
| Other values (7) | 23638 | 3.2% |
FI_UNINUM
Real number (ℝ)
High correlation 
| Distinct | 4577 |
|---|---|
| Distinct (%) | 5.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32378.417 |
| Minimum | 6 |
|---|---|
| Maximum | 650140 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 417 |
| Q1 | 2239 |
| median | 6212 |
| Q3 | 12494 |
| 95-th percentile | 82012 |
| Maximum | 650140 |
| Range | 650134 |
| Interquartile range (IQR) | 10255 |
Descriptive statistics
| Standard deviation | 94083.084 |
|---|---|
| Coefficient of variation (CV) | 2.9057345 |
| Kurtosis | 15.521056 |
| Mean | 32378.417 |
| Median Absolute Deviation (MAD) | 4088 |
| Skewness | 4.0901547 |
| Sum | 2.5754117 × 109 |
| Variance | 8.8516266 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 417 | 5141 | 6.5% |
| 2239 | 4366 | 5.5% |
| 2238 | 3977 | 5.0% |
| 4287 | 2375 | 3.0% |
| 4383 | 2299 | 2.9% |
| 6300 | 2005 | 2.5% |
| 7866 | 1282 | 1.6% |
| 12315 | 1184 | 1.5% |
| 4390 | 1177 | 1.5% |
| 4470 | 1079 | 1.4% |
| Other values (4567) | 54656 |
| Value | Count | Frequency (%) |
| 6 | 3 | < 0.1% |
| 17 | 8 | < 0.1% |
| 21 | 8 | < 0.1% |
| 23 | 4 | < 0.1% |
| 30 | 1 | < 0.1% |
| 31 | 7 | < 0.1% |
| 32 | 5 | < 0.1% |
| 33 | 1 | < 0.1% |
| 35 | 5 | < 0.1% |
| 39 | 21 |
| Value | Count | Frequency (%) |
| 650140 | 1 | < 0.1% |
| 649963 | 1 | < 0.1% |
| 647694 | 1 | < 0.1% |
| 645970 | 1 | < 0.1% |
| 644984 | 4 | |
| 641772 | 2 | |
| 641744 | 1 | < 0.1% |
| 641636 | 1 | < 0.1% |
| 640962 | 1 | < 0.1% |
| 640695 | 1 | < 0.1% |
ID
Real number (ℝ)
High correlation 
| Distinct | 79541 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 305329.74 |
| Minimum | 3 |
|---|---|
| Maximum | 663907 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 6214 |
| Q1 | 198678 |
| median | 263437 |
| Q3 | 464262 |
| 95-th percentile | 627297 |
| Maximum | 663907 |
| Range | 663904 |
| Interquartile range (IQR) | 265584 |
Descriptive statistics
| Standard deviation | 191723.6 |
|---|---|
| Coefficient of variation (CV) | 0.62792309 |
| Kurtosis | -0.95377428 |
| Mean | 305329.74 |
| Median Absolute Deviation (MAD) | 168927 |
| Skewness | 0.08674046 |
| Sum | 2.4286233 × 1010 |
| Variance | 3.6757937 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 629595 | 1 | < 0.1% |
| 223055 | 1 | < 0.1% |
| 232078 | 1 | < 0.1% |
| 466427 | 1 | < 0.1% |
| 9231 | 1 | < 0.1% |
| 429739 | 1 | < 0.1% |
| 641411 | 1 | < 0.1% |
| 641392 | 1 | < 0.1% |
| 632193 | 1 | < 0.1% |
| 621883 | 1 | < 0.1% |
| Other values (79531) | 79531 |
| Value | Count | Frequency (%) |
| 3 | 1 | |
| 4 | 1 | |
| 6 | 1 | |
| 8 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 15 | 1 | |
| 16 | 1 | |
| 17 | 1 | |
| 18 | 1 |
| Value | Count | Frequency (%) |
| 663907 | 1 | |
| 663906 | 1 | |
| 663905 | 1 | |
| 663904 | 1 | |
| 663898 | 1 | |
| 663897 | 1 | |
| 663896 | 1 | |
| 663886 | 1 | |
| 663885 | 1 | |
| 663876 | 1 |
LATITUDE
Real number (ℝ)
High correlation  Zeros 
| Distinct | 72751 |
|---|---|
| Distinct (%) | 91.5% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.080901 |
| Minimum | -24.892786 |
|---|---|
| Maximum | 71.293282 |
| Zeros | 5766 |
| Zeros (%) | 7.2% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | -24.892786 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 33.442709 |
| median | 38.3252 |
| Q3 | 41.248136 |
| 95-th percentile | 44.986226 |
| Maximum | 71.293282 |
| Range | 96.186068 |
| Interquartile range (IQR) | 7.8054265 |
Descriptive statistics
| Standard deviation | 11.030896 |
|---|---|
| Coefficient of variation (CV) | 0.31444165 |
| Kurtosis | 4.6456093 |
| Mean | 35.080901 |
| Median Absolute Deviation (MAD) | 3.797494 |
| Skewness | -2.2118584 |
| Sum | 2790369.9 |
| Variance | 121.68068 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5766 | 7.2% |
| 38.97345401 | 11 | < 0.1% |
| 33.50985786 | 9 | < 0.1% |
| 18.210621 | 8 | < 0.1% |
| 18.347484 | 8 | < 0.1% |
| 18.103866 | 6 | < 0.1% |
| 29.42687902 | 6 | < 0.1% |
| 44.97609999 | 6 | < 0.1% |
| 43.08686201 | 5 | < 0.1% |
| 42.934779 | 5 | < 0.1% |
| Other values (72741) | 73711 |
| Value | Count | Frequency (%) |
| -24.89278582 | 1 | < 0.1% |
| 0 | 5766 | |
| 5.32492 | 1 | < 0.1% |
| 6.964 | 2 | < 0.1% |
| 7.34391 | 1 | < 0.1% |
| 7.34449 | 1 | < 0.1% |
| 7.44369 | 1 | < 0.1% |
| 7.44413 | 1 | < 0.1% |
| 13.39932359 | 1 | < 0.1% |
| 13.4378134 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 71.293282 | 1 | |
| 66.892278 | 1 | |
| 66.56444 | 1 | |
| 64.85844899 | 1 | |
| 64.85833001 | 1 | |
| 64.855525 | 1 | |
| 64.85161401 | 1 | |
| 64.85093201 | 1 | |
| 64.848722 | 1 | |
| 64.846762 | 1 |
LONGITUDE
Real number (ℝ)
High correlation  Zeros 
| Distinct | 72774 |
|---|---|
| Distinct (%) | 91.5% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -83.77563 |
| Minimum | -166.24856 |
|---|---|
| Maximum | 163.01083 |
| Zeros | 5766 |
| Zeros (%) | 7.2% |
| Negative | 73745 |
| Negative (%) | 92.7% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | -166.24856 |
|---|---|
| 5-th percentile | -121.1656 |
| Q1 | -95.931608 |
| median | -85.90069 |
| Q3 | -77.369721 |
| 95-th percentile | 0 |
| Maximum | 163.01083 |
| Range | 329.25939 |
| Interquartile range (IQR) | 18.561887 |
Descriptive statistics
| Standard deviation | 27.774008 |
|---|---|
| Coefficient of variation (CV) | -0.33152849 |
| Kurtosis | 5.2581445 |
| Mean | -83.77563 |
| Median Absolute Deviation (MAD) | 9.340965 |
| Skewness | 1.8487707 |
| Sum | -6663597.4 |
| Variance | 771.39555 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5766 | 7.2% |
| -92.296582 | 11 | < 0.1% |
| -112.0348945 | 9 | < 0.1% |
| -66.028075 | 8 | < 0.1% |
| -66.059463 | 8 | < 0.1% |
| -98.495664 | 6 | < 0.1% |
| -66.625687 | 6 | < 0.1% |
| -93.27205096 | 5 | < 0.1% |
| -85.51531002 | 5 | < 0.1% |
| -85.49964299 | 5 | < 0.1% |
| Other values (72764) | 73712 |
| Value | Count | Frequency (%) |
| -166.2485582 | 1 | |
| -165.4092107 | 1 | |
| -165.4082716 | 1 | |
| -162.592615 | 1 | |
| -161.759877 | 1 | |
| -161.7517956 | 1 | |
| -159.72357 | 1 | |
| -159.585582 | 1 | |
| -159.476557 | 1 | |
| -159.4735174 | 1 |
| Value | Count | Frequency (%) |
| 163.01083 | 1 | |
| 158.2056 | 2 | |
| 151.84316 | 1 | |
| 151.84113 | 1 | |
| 145.760035 | 1 | |
| 145.7188384 | 2 | |
| 145.7172201 | 1 | |
| 145.6210308 | 1 | |
| 145.227823 | 1 | |
| 144.8843036 | 1 |
MAINOFF
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 621.6 KiB |
| 0.0 | |
|---|---|
| 1.0 | 4577 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 74964 | |
| 1.0 | 4577 | 5.8% |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 74964 | |
| 1.0 | 4577 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 154505 | |
| . | 79541 | |
| 1 | 4577 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 154505 | |
| . | 79541 | |
| 1 | 4577 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 154505 | |
| . | 79541 | |
| 1 | 4577 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238623 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 154505 | |
| . | 79541 | |
| 1 | 4577 | 1.9% |
MDI_STATUS_CODE
Unsupported
Missing  Rejected  Unsupported 
| Missing | 77963 |
|---|---|
| Missing (%) | 98.0% |
| Memory size | 621.6 KiB |
MDI_STATUS_DESC
Categorical
High correlation  Missing 
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 77963 |
| Missing (%) | 98.0% |
| Memory size | 621.6 KiB |
| MINORITY BOARD AND SERVING HISPANIC COMMUNITY | |
|---|---|
| ASIAN OR PACIFIC ISLANDER AMERICANS | |
| MINORITY BOARD AND SERVING ASIAN OR PACIFIC ISLANDER COMMUNITY | |
| HISPANIC AMERICAN | |
| NATIVE AMERICAN OR NATIVE ALASKAN AMERICAN | |
| Other values (6) |
Length
| Max length | 62 |
|---|---|
| Median length | 53 |
| Mean length | 41.644712 |
| Min length | 4 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | ASIAN OR PACIFIC ISLANDER AMERICANS |
|---|---|
| 2nd row | ASIAN OR PACIFIC ISLANDER AMERICANS |
| 3rd row | ASIAN OR PACIFIC ISLANDER AMERICANS |
| 4th row | ASIAN OR PACIFIC ISLANDER AMERICANS |
| 5th row | ASIAN OR PACIFIC ISLANDER AMERICANS |
Common Values
| Value | Count | Frequency (%) |
| MINORITY BOARD AND SERVING HISPANIC COMMUNITY | 510 | 0.6% |
| ASIAN OR PACIFIC ISLANDER AMERICANS | 409 | 0.5% |
| MINORITY BOARD AND SERVING ASIAN OR PACIFIC ISLANDER COMMUNITY | 310 | 0.4% |
| HISPANIC AMERICAN | 134 | 0.2% |
| NATIVE AMERICAN OR NATIVE ALASKAN AMERICAN | 105 | 0.1% |
| AFRICAN AMERICAN | 79 | 0.1% |
| MINORITY BOARD AND SERVING AFRICAN AMERICAN COMMUNITY | 21 | < 0.1% |
| NONE | 6 | < 0.1% |
| MINORITY BOARD AND SERVING MULTI-RACIAL COMMUNITY | 3 | < 0.1% |
| MDI_STATUS_DESC | 1 | < 0.1% |
| (Missing) | 77963 |
Length
| Value | Count | Frequency (%) |
| minority | 844 | |
| board | 844 | |
| and | 844 | |
| serving | 844 | |
| community | 844 | |
| or | 824 | |
| pacific | 719 | |
| asian | 719 | |
| islander | 719 | |
| hispanic | 644 | |
| Other values (8) | 1280 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 8713 | |
| A | 7650 | |
| 7546 | ||
| N | 6739 | |
| R | 5033 | 7.7% |
| C | 3885 | 5.9% |
| S | 3443 | 5.2% |
| M | 3391 | 5.2% |
| O | 3362 | 5.1% |
| E | 2634 | 4.0% |
| Other values (14) | 13361 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65757 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 8713 | |
| A | 7650 | |
| 7546 | ||
| N | 6739 | |
| R | 5033 | 7.7% |
| C | 3885 | 5.9% |
| S | 3443 | 5.2% |
| M | 3391 | 5.2% |
| O | 3362 | 5.1% |
| E | 2634 | 4.0% |
| Other values (14) | 13361 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65757 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 8713 | |
| A | 7650 | |
| 7546 | ||
| N | 6739 | |
| R | 5033 | 7.7% |
| C | 3885 | 5.9% |
| S | 3443 | 5.2% |
| M | 3391 | 5.2% |
| O | 3362 | 5.1% |
| E | 2634 | 4.0% |
| Other values (14) | 13361 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65757 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 8713 | |
| A | 7650 | |
| 7546 | ||
| N | 6739 | |
| R | 5033 | 7.7% |
| C | 3885 | 5.9% |
| S | 3443 | 5.2% |
| M | 3391 | 5.2% |
| O | 3362 | 5.1% |
| E | 2634 | 4.0% |
| Other values (14) | 13361 |
NAME
Text
| Distinct | 4016 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 68 |
|---|---|
| Median length | 56 |
| Mean length | 25.620867 |
| Min length | 3 |
Unique
| Unique | 704 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | 1NB Bank |
|---|---|
| 2nd row | 1NB Bank |
| 3rd row | 1NB Bank |
| 4th row | 1NB Bank |
| 5th row | 1st Advantage Bank |
| Value | Count | Frequency (%) |
| bank | 72321 | |
| national | 35733 | 12.2% |
| association | 28951 | 9.9% |
| of | 9981 | 3.4% |
| first | 6776 | 2.3% |
| trust | 6207 | 2.1% |
| the | 5258 | 1.8% |
| chase | 5142 | 1.8% |
| jpmorgan | 5142 | 1.8% |
| wells | 4375 | 1.5% |
| Other values (2681) | 112192 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 247526 | |
| 212925 | 10.4% | |
| n | 202241 | 9.9% |
| i | 151721 | 7.4% |
| o | 150523 | 7.4% |
| t | 125249 | 6.1% |
| s | 112556 | 5.5% |
| B | 81439 | 4.0% |
| k | 78621 | 3.9% |
| e | 72465 | 3.6% |
| Other values (61) | 602669 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2037935 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 247526 | |
| 212925 | 10.4% | |
| n | 202241 | 9.9% |
| i | 151721 | 7.4% |
| o | 150523 | 7.4% |
| t | 125249 | 6.1% |
| s | 112556 | 5.5% |
| B | 81439 | 4.0% |
| k | 78621 | 3.9% |
| e | 72465 | 3.6% |
| Other values (61) | 602669 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2037935 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 247526 | |
| 212925 | 10.4% | |
| n | 202241 | 9.9% |
| i | 151721 | 7.4% |
| o | 150523 | 7.4% |
| t | 125249 | 6.1% |
| s | 112556 | 5.5% |
| B | 81439 | 4.0% |
| k | 78621 | 3.9% |
| e | 72465 | 3.6% |
| Other values (61) | 602669 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2037935 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 247526 | |
| 212925 | 10.4% | |
| n | 202241 | 9.9% |
| i | 151721 | 7.4% |
| o | 150523 | 7.4% |
| t | 125249 | 6.1% |
| s | 112556 | 5.5% |
| B | 81439 | 4.0% |
| k | 78621 | 3.9% |
| e | 72465 | 3.6% |
| Other values (61) | 602669 |
OFFNAME
Text
| Distinct | 51238 |
|---|---|
| Distinct (%) | 64.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 93 |
|---|---|
| Median length | 69 |
| Mean length | 20.07865 |
| Min length | 3 |
Unique
| Unique | 42175 ? |
|---|---|
| Unique (%) | 53.0% |
Sample
| 1st row | ST. ROSE FACILITY BRANCH |
|---|---|
| 2nd row | 1350 12TH STREET FACILITY |
| 3rd row | AVISTON BRANCH |
| 4th row | 1NB Bank |
| 5th row | 1st Advantage Bank |
| Value | Count | Frequency (%) |
| branch | 69727 | |
| bank | 6361 | 2.7% |
| 3614 | 1.5% | |
| center | 2868 | 1.2% |
| street | 2211 | 0.9% |
| main | 2039 | 0.9% |
| and | 1917 | 0.8% |
| office | 1871 | 0.8% |
| west | 1787 | 0.7% |
| banking | 1755 | 0.7% |
| Other values (18828) | 144855 |
Most occurring characters
| Value | Count | Frequency (%) |
| 160059 | 10.0% | |
| A | 135262 | 8.5% |
| N | 127057 | 8.0% |
| R | 120499 | 7.5% |
| B | 93985 | 5.9% |
| C | 91654 | 5.7% |
| H | 84757 | 5.3% |
| E | 82327 | 5.2% |
| O | 57740 | 3.6% |
| T | 53707 | 3.4% |
| Other values (71) | 590049 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1597096 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 160059 | 10.0% | |
| A | 135262 | 8.5% |
| N | 127057 | 8.0% |
| R | 120499 | 7.5% |
| B | 93985 | 5.9% |
| C | 91654 | 5.7% |
| H | 84757 | 5.3% |
| E | 82327 | 5.2% |
| O | 57740 | 3.6% |
| T | 53707 | 3.4% |
| Other values (71) | 590049 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1597096 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 160059 | 10.0% | |
| A | 135262 | 8.5% |
| N | 127057 | 8.0% |
| R | 120499 | 7.5% |
| B | 93985 | 5.9% |
| C | 91654 | 5.7% |
| H | 84757 | 5.3% |
| E | 82327 | 5.2% |
| O | 57740 | 3.6% |
| T | 53707 | 3.4% |
| Other values (71) | 590049 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1597096 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 160059 | 10.0% | |
| A | 135262 | 8.5% |
| N | 127057 | 8.0% |
| R | 120499 | 7.5% |
| B | 93985 | 5.9% |
| C | 91654 | 5.7% |
| H | 84757 | 5.3% |
| E | 82327 | 5.2% |
| O | 57740 | 3.6% |
| T | 53707 | 3.4% |
| Other values (71) | 590049 |
OFFNUM
Real number (ℝ)
High correlation  Zeros 
| Distinct | 9708 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1410.45 |
| Minimum | 0 |
|---|---|
| Maximum | 10535 |
| Zeros | 4577 |
| Zeros (%) | 5.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 11 |
| median | 143 |
| Q3 | 1616 |
| 95-th percentile | 7774 |
| Maximum | 10535 |
| Range | 10535 |
| Interquartile range (IQR) | 1605 |
Descriptive statistics
| Standard deviation | 2442.1824 |
|---|---|
| Coefficient of variation (CV) | 1.7314917 |
| Kurtosis | 3.0629177 |
| Mean | 1410.45 |
| Median Absolute Deviation (MAD) | 142 |
| Skewness | 2.0075251 |
| Sum | 1.121886 × 108 |
| Variance | 5964254.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4577 | 5.8% |
| 1 | 2512 | 3.2% |
| 2 | 2319 | 2.9% |
| 3 | 1959 | 2.5% |
| 4 | 1689 | 2.1% |
| 5 | 1471 | 1.8% |
| 6 | 1282 | 1.6% |
| 7 | 1123 | 1.4% |
| 8 | 998 | 1.3% |
| 9 | 897 | 1.1% |
| Other values (9698) | 60714 |
| Value | Count | Frequency (%) |
| 0 | 4577 | |
| 1 | 2512 | |
| 2 | 2319 | |
| 3 | 1959 | |
| 4 | 1689 | 2.1% |
| 5 | 1471 | 1.8% |
| 6 | 1282 | 1.6% |
| 7 | 1123 | 1.4% |
| 8 | 998 | 1.3% |
| 9 | 897 | 1.1% |
| Value | Count | Frequency (%) |
| 10535 | 1 | |
| 10534 | 1 | |
| 10533 | 1 | |
| 10532 | 1 | |
| 10531 | 1 | |
| 10530 | 1 | |
| 10529 | 1 | |
| 10528 | 1 | |
| 10527 | 1 | |
| 10526 | 1 |
RUNDATE
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 621.6 KiB |
| 45401.0 |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 45401.0 |
|---|---|
| 2nd row | 45401.0 |
| 3rd row | 45401.0 |
| 4th row | 45401.0 |
| 5th row | 45401.0 |
Common Values
| Value | Count | Frequency (%) |
| 45401.0 | 79541 | |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 45401.0 | 79541 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 159082 | |
| 0 | 159082 | |
| 5 | 79541 | |
| 1 | 79541 | |
| . | 79541 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 556787 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 159082 | |
| 0 | 159082 | |
| 5 | 79541 | |
| 1 | 79541 | |
| . | 79541 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 556787 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 159082 | |
| 0 | 159082 | |
| 5 | 79541 | |
| 1 | 79541 | |
| . | 79541 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 556787 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 159082 | |
| 0 | 159082 | |
| 5 | 79541 | |
| 1 | 79541 | |
| . | 79541 |
SERVTYPE
Real number (ℝ)
High correlation 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.734791 |
| Minimum | 11 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 11 |
| median | 11 |
| Q3 | 11 |
| 95-th percentile | 13 |
| Maximum | 99 |
| Range | 88 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.6552091 |
|---|---|
| Coefficient of variation (CV) | 0.31148481 |
| Kurtosis | 210.17446 |
| Mean | 11.734791 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.826712 |
| Sum | 933397 |
| Variance | 13.360553 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 72967 | |
| 12 | 2575 | 3.2% |
| 23 | 1537 | 1.9% |
| 24 | 892 | 1.1% |
| 29 | 359 | 0.5% |
| 27 | 310 | 0.4% |
| 21 | 249 | 0.3% |
| 30 | 178 | 0.2% |
| 13 | 177 | 0.2% |
| 26 | 154 | 0.2% |
| Other values (4) | 143 | 0.2% |
| Value | Count | Frequency (%) |
| 11 | 72967 | |
| 12 | 2575 | 3.2% |
| 13 | 177 | 0.2% |
| 21 | 249 | 0.3% |
| 22 | 4 | < 0.1% |
| 23 | 1537 | 1.9% |
| 24 | 892 | 1.1% |
| 25 | 28 | < 0.1% |
| 26 | 154 | 0.2% |
| 27 | 310 | 0.4% |
| Value | Count | Frequency (%) |
| 99 | 50 | 0.1% |
| 30 | 178 | 0.2% |
| 29 | 359 | 0.5% |
| 28 | 61 | 0.1% |
| 27 | 310 | 0.4% |
| 26 | 154 | 0.2% |
| 25 | 28 | < 0.1% |
| 24 | 892 | |
| 23 | 1537 | |
| 22 | 4 | < 0.1% |
SERVTYPE_DESC
Categorical
High correlation  Imbalance 
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 621.6 KiB |
| FULL SERVICE - BRICK AND MORTAR | |
|---|---|
| FULL SERVICE - RETAIL | 2575 |
| LIMITED SERVICE - DRIVE THRU/DETACHED FACILITY | 1537 |
| LIMITED SERVICE - LOAN PRODUCTION | 892 |
| LIMITED SERVICE - MOBILE/SEASONAL | 359 |
| Other values (10) | 1212 |
Length
| Max length | 46 |
|---|---|
| Median length | 31 |
| Mean length | 30.953521 |
| Min length | 13 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | FULL SERVICE - BRICK AND MORTAR |
|---|---|
| 2nd row | FULL SERVICE - BRICK AND MORTAR |
| 3rd row | FULL SERVICE - BRICK AND MORTAR |
| 4th row | FULL SERVICE - BRICK AND MORTAR |
| 5th row | FULL SERVICE - BRICK AND MORTAR |
Common Values
| Value | Count | Frequency (%) |
| FULL SERVICE - BRICK AND MORTAR | 72967 | |
| FULL SERVICE - RETAIL | 2575 | 3.2% |
| LIMITED SERVICE - DRIVE THRU/DETACHED FACILITY | 1537 | 1.9% |
| LIMITED SERVICE - LOAN PRODUCTION | 892 | 1.1% |
| LIMITED SERVICE - MOBILE/SEASONAL | 359 | 0.5% |
| LIMITED SERVICE - MESSENGER | 310 | 0.4% |
| LIMITED SERVICE - ADMINISTRATIVE | 249 | 0.3% |
| LIMITED SERVICE - TRUST | 178 | 0.2% |
| FULL SERVICE - HOME BANKING | 177 | 0.2% |
| LIMITED SERVICE - CONTRACTUAL | 154 | 0.2% |
| Other values (5) | 144 | 0.2% |
Length
| Value | Count | Frequency (%) |
| service | 79541 | |
| 79541 | ||
| full | 75719 | |
| brick | 72967 | |
| and | 72967 | |
| mortar | 72967 | |
| limited | 3822 | 0.8% |
| retail | 2636 | 0.6% |
| facility | 1541 | 0.3% |
| drive | 1537 | 0.3% |
| Other values (16) | 5086 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 388782 | ||
| R | 306096 | |
| E | 172384 | 7.0% |
| I | 169668 | 6.9% |
| L | 161205 | 6.5% |
| C | 156943 | 6.4% |
| A | 154295 | 6.3% |
| T | 86177 | 3.5% |
| D | 82570 | 3.4% |
| S | 81336 | 3.3% |
| Other values (15) | 702649 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2462105 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 388782 | ||
| R | 306096 | |
| E | 172384 | 7.0% |
| I | 169668 | 6.9% |
| L | 161205 | 6.5% |
| C | 156943 | 6.4% |
| A | 154295 | 6.3% |
| T | 86177 | 3.5% |
| D | 82570 | 3.4% |
| S | 81336 | 3.3% |
| Other values (15) | 702649 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2462105 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 388782 | ||
| R | 306096 | |
| E | 172384 | 7.0% |
| I | 169668 | 6.9% |
| L | 161205 | 6.5% |
| C | 156943 | 6.4% |
| A | 154295 | 6.3% |
| T | 86177 | 3.5% |
| D | 82570 | 3.4% |
| S | 81336 | 3.3% |
| Other values (15) | 702649 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2462105 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 388782 | ||
| R | 306096 | |
| E | 172384 | 7.0% |
| I | 169668 | 6.9% |
| L | 161205 | 6.5% |
| C | 156943 | 6.4% |
| A | 154295 | 6.3% |
| T | 86177 | 3.5% |
| D | 82570 | 3.4% |
| S | 81336 | 3.3% |
| Other values (15) | 702649 |
STALP
Text
Missing 
| Distinct | 59 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 803 |
| Missing (%) | 1.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.0000381 |
| Min length | 2 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | IL |
|---|---|
| 2nd row | IL |
| 3rd row | IL |
| 4th row | IL |
| 5th row | MO |
| Value | Count | Frequency (%) |
| tx | 6359 | 8.1% |
| ca | 5770 | 7.3% |
| fl | 4349 | 5.5% |
| ny | 4151 | 5.3% |
| il | 3721 | 4.7% |
| pa | 3473 | 4.4% |
| oh | 3127 | 4.0% |
| nj | 2350 | 3.0% |
| mi | 2177 | 2.8% |
| mo | 2153 | 2.7% |
| Other values (49) | 41109 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 23243 | |
| N | 16661 | |
| I | 11738 | 7.5% |
| C | 11560 | 7.3% |
| M | 11436 | 7.3% |
| L | 10823 | 6.9% |
| T | 10498 | 6.7% |
| O | 8743 | 5.6% |
| X | 6359 | 4.0% |
| Y | 5881 | 3.7% |
| Other values (14) | 40539 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 157481 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 23243 | |
| N | 16661 | |
| I | 11738 | 7.5% |
| C | 11560 | 7.3% |
| M | 11436 | 7.3% |
| L | 10823 | 6.9% |
| T | 10498 | 6.7% |
| O | 8743 | 5.6% |
| X | 6359 | 4.0% |
| Y | 5881 | 3.7% |
| Other values (14) | 40539 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 157481 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 23243 | |
| N | 16661 | |
| I | 11738 | 7.5% |
| C | 11560 | 7.3% |
| M | 11436 | 7.3% |
| L | 10823 | 6.9% |
| T | 10498 | 6.7% |
| O | 8743 | 5.6% |
| X | 6359 | 4.0% |
| Y | 5881 | 3.7% |
| Other values (14) | 40539 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 157481 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 23243 | |
| N | 16661 | |
| I | 11738 | 7.5% |
| C | 11560 | 7.3% |
| M | 11436 | 7.3% |
| L | 10823 | 6.9% |
| T | 10498 | 6.7% |
| O | 8743 | 5.6% |
| X | 6359 | 4.0% |
| Y | 5881 | 3.7% |
| Other values (14) | 40539 |
STCNTY
Real number (ℝ)
High correlation  Zeros 
| Distinct | 3198 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28538.94 |
| Minimum | 0 |
|---|---|
| Maximum | 78030 |
| Zeros | 803 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5085 |
| Q1 | 16001 |
| median | 28115 |
| Q3 | 42017 |
| 95-th percentile | 53031 |
| Maximum | 78030 |
| Range | 78030 |
| Interquartile range (IQR) | 26016 |
Descriptive statistics
| Standard deviation | 15864.222 |
|---|---|
| Coefficient of variation (CV) | 0.55587988 |
| Kurtosis | -1.0749524 |
| Mean | 28538.94 |
| Median Absolute Deviation (MAD) | 13894 |
| Skewness | 0.0097804197 |
| Sum | 2.2700158 × 109 |
| Variance | 2.5167355 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6037 | 1466 | 1.8% |
| 17031 | 1155 | 1.5% |
| 48201 | 885 | 1.1% |
| 0 | 803 | 1.0% |
| 4013 | 666 | 0.8% |
| 48113 | 597 | 0.8% |
| 12086 | 581 | 0.7% |
| 6059 | 557 | 0.7% |
| 36061 | 551 | 0.7% |
| 6073 | 469 | 0.6% |
| Other values (3188) | 71811 |
| Value | Count | Frequency (%) |
| 0 | 803 | |
| 1001 | 15 | < 0.1% |
| 1003 | 89 | 0.1% |
| 1005 | 10 | < 0.1% |
| 1007 | 7 | < 0.1% |
| 1009 | 14 | < 0.1% |
| 1011 | 2 | < 0.1% |
| 1013 | 9 | < 0.1% |
| 1015 | 29 | < 0.1% |
| 1017 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 78030 | 9 | |
| 78020 | 2 | < 0.1% |
| 78010 | 9 | |
| 72153 | 4 | |
| 72151 | 2 | < 0.1% |
| 72149 | 1 | < 0.1% |
| 72147 | 1 | < 0.1% |
| 72145 | 3 | < 0.1% |
| 72143 | 1 | < 0.1% |
| 72141 | 1 | < 0.1% |
STNAME
Text
Missing 
| Distinct | 59 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 803 |
| Missing (%) | 1.0% |
| Memory size | 621.6 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 24 |
| Mean length | 8.3739697 |
| Min length | 4 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Illinois |
|---|---|
| 2nd row | Illinois |
| 3rd row | Illinois |
| 4th row | Illinois |
| 5th row | Missouri |
| Value | Count | Frequency (%) |
| new | 7309 | 8.0% |
| texas | 6359 | 6.9% |
| california | 5770 | 6.3% |
| florida | 4349 | 4.7% |
| york | 4151 | 4.5% |
| illinois | 3721 | 4.1% |
| pennsylvania | 3473 | 3.8% |
| carolina | 3216 | 3.5% |
| ohio | 3127 | 3.4% |
| north | 2456 | 2.7% |
| Other values (60) | 47765 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 82914 | |
| i | 71373 | 10.8% |
| n | 57355 | 8.7% |
| s | 52334 | 7.9% |
| o | 51967 | 7.9% |
| e | 43409 | 6.6% |
| r | 37085 | 5.6% |
| l | 30365 | 4.6% |
| t | 17740 | 2.7% |
| h | 15700 | 2.4% |
| Other values (38) | 199116 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 659358 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 82914 | |
| i | 71373 | 10.8% |
| n | 57355 | 8.7% |
| s | 52334 | 7.9% |
| o | 51967 | 7.9% |
| e | 43409 | 6.6% |
| r | 37085 | 5.6% |
| l | 30365 | 4.6% |
| t | 17740 | 2.7% |
| h | 15700 | 2.4% |
| Other values (38) | 199116 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 659358 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 82914 | |
| i | 71373 | 10.8% |
| n | 57355 | 8.7% |
| s | 52334 | 7.9% |
| o | 51967 | 7.9% |
| e | 43409 | 6.6% |
| r | 37085 | 5.6% |
| l | 30365 | 4.6% |
| t | 17740 | 2.7% |
| h | 15700 | 2.4% |
| Other values (38) | 199116 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 659358 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 82914 | |
| i | 71373 | 10.8% |
| n | 57355 | 8.7% |
| s | 52334 | 7.9% |
| o | 51967 | 7.9% |
| e | 43409 | 6.6% |
| r | 37085 | 5.6% |
| l | 30365 | 4.6% |
| t | 17740 | 2.7% |
| h | 15700 | 2.4% |
| Other values (38) | 199116 |
UNINUM
Real number (ℝ)
High correlation 
| Distinct | 79541 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 305329.74 |
| Minimum | 3 |
|---|---|
| Maximum | 663907 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 6214 |
| Q1 | 198678 |
| median | 263437 |
| Q3 | 464262 |
| 95-th percentile | 627297 |
| Maximum | 663907 |
| Range | 663904 |
| Interquartile range (IQR) | 265584 |
Descriptive statistics
| Standard deviation | 191723.6 |
|---|---|
| Coefficient of variation (CV) | 0.62792309 |
| Kurtosis | -0.95377428 |
| Mean | 305329.74 |
| Median Absolute Deviation (MAD) | 168927 |
| Skewness | 0.08674046 |
| Sum | 2.4286233 × 1010 |
| Variance | 3.6757937 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 629595 | 1 | < 0.1% |
| 223055 | 1 | < 0.1% |
| 232078 | 1 | < 0.1% |
| 466427 | 1 | < 0.1% |
| 9231 | 1 | < 0.1% |
| 429739 | 1 | < 0.1% |
| 641411 | 1 | < 0.1% |
| 641392 | 1 | < 0.1% |
| 632193 | 1 | < 0.1% |
| 621883 | 1 | < 0.1% |
| Other values (79531) | 79531 |
| Value | Count | Frequency (%) |
| 3 | 1 | |
| 4 | 1 | |
| 6 | 1 | |
| 8 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 15 | 1 | |
| 16 | 1 | |
| 17 | 1 | |
| 18 | 1 |
| Value | Count | Frequency (%) |
| 663907 | 1 | |
| 663906 | 1 | |
| 663905 | 1 | |
| 663904 | 1 | |
| 663898 | 1 | |
| 663897 | 1 | |
| 663896 | 1 | |
| 663886 | 1 | |
| 663885 | 1 | |
| 663876 | 1 |
ZIP
Real number (ℝ)
High correlation 
| Distinct | 18284 |
|---|---|
| Distinct (%) | 23.0% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48949.246 |
| Minimum | 0 |
|---|---|
| Maximum | 99929 |
| Zeros | 794 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 621.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4602.3 |
| Q1 | 27540 |
| median | 47715 |
| Q3 | 73529 |
| 95-th percentile | 94591 |
| Maximum | 99929 |
| Range | 99929 |
| Interquartile range (IQR) | 45989 |
Descriptive statistics
| Standard deviation | 28237.231 |
|---|---|
| Coefficient of variation (CV) | 0.57686753 |
| Kurtosis | -1.1186076 |
| Mean | 48949.246 |
| Median Absolute Deviation (MAD) | 24111 |
| Skewness | 0.041589 |
| Sum | 3.8933741 × 109 |
| Variance | 7.9734121 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 794 | 1.0% |
| 10022 | 56 | 0.1% |
| 33134 | 47 | 0.1% |
| 75225 | 46 | 0.1% |
| 85016 | 43 | 0.1% |
| 33131 | 43 | 0.1% |
| 72401 | 41 | 0.1% |
| 37027 | 41 | 0.1% |
| 17601 | 40 | 0.1% |
| 76107 | 40 | 0.1% |
| Other values (18274) | 78348 |
| Value | Count | Frequency (%) |
| 0 | 794 | |
| 100 | 1 | < 0.1% |
| 601 | 1 | < 0.1% |
| 602 | 2 | < 0.1% |
| 603 | 4 | < 0.1% |
| 604 | 1 | < 0.1% |
| 606 | 1 | < 0.1% |
| 610 | 1 | < 0.1% |
| 612 | 5 | < 0.1% |
| 617 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99929 | 2 | < 0.1% |
| 99921 | 2 | < 0.1% |
| 99901 | 6 | |
| 99840 | 1 | < 0.1% |
| 99835 | 4 | |
| 99833 | 2 | < 0.1% |
| 99827 | 1 | < 0.1% |
| 99801 | 9 | |
| 99780 | 1 | < 0.1% |
| 99762 | 2 | < 0.1% |
Interactions
Correlations
| ACQDATE | BKCLASS | CBSA_DIV | CBSA_DIV_FLG | CBSA_DIV_NO | CBSA_METRO | CBSA_METRO_FLG | CBSA_MICRO_FLG | CBSA_NO | CERT | CSA_FLG | CSA_NO | FI_UNINUM | ID | LATITUDE | LONGITUDE | MAINOFF | MDI_STATUS_DESC | OBJECTID | OFFNUM | SERVTYPE | SERVTYPE_DESC | STCNTY | UNINUM | X | Y | ZIP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACQDATE | 1.000 | 0.160 | 0.185 | 0.132 | 0.018 | 0.003 | 0.106 | 0.081 | -0.006 | 0.200 | 0.076 | -0.011 | 0.202 | 0.326 | -0.117 | 0.008 | 1.000 | 0.281 | 0.019 | 0.012 | 0.044 | 0.071 | -0.035 | 0.326 | 0.008 | -0.117 | 0.018 |
| BKCLASS | 0.160 | 1.000 | 0.410 | 0.191 | 0.120 | 0.085 | 0.115 | 0.115 | 0.075 | 0.309 | 0.114 | 0.096 | 0.061 | 0.097 | 0.058 | 0.062 | 0.179 | 0.478 | 0.152 | 0.221 | 0.048 | 0.384 | 0.100 | 0.097 | 0.062 | 0.058 | 0.158 |
| CBSA_DIV | 0.185 | 0.410 | 1.000 | 1.000 | 0.999 | 0.999 | 1.000 | 1.000 | 0.999 | 0.221 | 1.000 | 0.999 | 0.103 | 0.138 | 0.764 | 0.607 | 0.077 | 0.459 | 0.168 | 0.192 | 0.099 | 0.298 | 0.904 | 0.138 | 0.607 | 0.764 | 0.927 |
| CBSA_DIV_FLG | 0.132 | 0.191 | 1.000 | 1.000 | 1.000 | 0.513 | 0.359 | 0.162 | 0.463 | 0.127 | 0.391 | 0.507 | 0.079 | 0.095 | 0.090 | 0.178 | 0.057 | 0.225 | 0.107 | 0.166 | 0.041 | 0.051 | 0.324 | 0.095 | 0.178 | 0.090 | 0.371 |
| CBSA_DIV_NO | 0.018 | 0.120 | 0.999 | 1.000 | 1.000 | 0.973 | 1.000 | 1.000 | 0.973 | 0.026 | 1.000 | 0.973 | 0.025 | 0.160 | 0.271 | 0.415 | 0.104 | 0.300 | 0.030 | 0.253 | -0.026 | 0.046 | 0.535 | 0.160 | 0.415 | 0.271 | -0.422 |
| CBSA_METRO | 0.003 | 0.085 | 0.999 | 0.513 | 0.973 | 1.000 | 1.000 | 0.452 | 0.821 | 0.035 | 0.712 | 0.839 | 0.033 | 0.125 | 0.067 | 0.273 | 0.092 | 0.285 | 0.029 | 0.155 | -0.014 | 0.057 | 0.356 | 0.125 | 0.273 | 0.067 | -0.275 |
| CBSA_METRO_FLG | 0.106 | 0.115 | 1.000 | 0.359 | 1.000 | 1.000 | 1.000 | 0.452 | 0.792 | 0.086 | 0.694 | 0.872 | 0.057 | 0.163 | 0.139 | 0.356 | 0.090 | 0.454 | 0.058 | 0.143 | 0.038 | 0.061 | 0.541 | 0.163 | 0.356 | 0.139 | 0.387 |
| CBSA_MICRO_FLG | 0.081 | 0.115 | 1.000 | 0.162 | 1.000 | 0.452 | 0.452 | 1.000 | 0.246 | 0.079 | 0.059 | 0.207 | 0.037 | 0.115 | 0.101 | 0.049 | 0.067 | 0.288 | 0.104 | 0.149 | 0.042 | 0.065 | 0.180 | 0.115 | 0.049 | 0.101 | 0.159 |
| CBSA_NO | -0.006 | 0.075 | 0.999 | 0.463 | 0.973 | 0.821 | 0.792 | 0.246 | 1.000 | 0.058 | 0.739 | 0.905 | 0.057 | 0.066 | 0.104 | 0.252 | 0.063 | 0.287 | 0.035 | 0.052 | -0.001 | 0.044 | 0.414 | 0.066 | 0.252 | 0.104 | -0.262 |
| CERT | 0.200 | 0.309 | 0.221 | 0.127 | 0.026 | 0.035 | 0.086 | 0.079 | 0.058 | 1.000 | 0.068 | 0.029 | 0.999 | 0.130 | 0.080 | 0.094 | 0.113 | 0.430 | -0.048 | -0.440 | 0.052 | 0.082 | 0.086 | 0.130 | 0.094 | 0.080 | -0.093 |
| CSA_FLG | 0.076 | 0.114 | 1.000 | 0.391 | 1.000 | 0.712 | 0.694 | 0.059 | 0.739 | 0.068 | 1.000 | 1.000 | 0.043 | 0.122 | 0.070 | 0.345 | 0.069 | 0.405 | 0.066 | 0.113 | 0.026 | 0.045 | 0.511 | 0.122 | 0.345 | 0.070 | 0.377 |
| CSA_NO | -0.011 | 0.096 | 0.999 | 0.507 | 0.973 | 0.839 | 0.872 | 0.207 | 0.905 | 0.029 | 1.000 | 1.000 | 0.030 | 0.088 | 0.123 | 0.279 | 0.072 | 0.340 | 0.051 | 0.105 | -0.002 | 0.065 | 0.472 | 0.088 | 0.279 | 0.123 | -0.267 |
| FI_UNINUM | 0.202 | 0.061 | 0.103 | 0.079 | 0.025 | 0.033 | 0.057 | 0.037 | 0.057 | 0.999 | 0.043 | 0.030 | 1.000 | 0.129 | 0.077 | 0.090 | 0.110 | 0.396 | -0.048 | -0.438 | 0.052 | 0.031 | 0.087 | 0.129 | 0.090 | 0.077 | -0.088 |
| ID | 0.326 | 0.097 | 0.138 | 0.095 | 0.160 | 0.125 | 0.163 | 0.115 | 0.066 | 0.130 | 0.122 | 0.088 | 0.129 | 1.000 | -0.138 | 0.056 | 0.468 | 0.141 | -0.002 | 0.112 | 0.168 | 0.103 | -0.009 | 1.000 | 0.056 | -0.138 | -0.001 |
| LATITUDE | -0.117 | 0.058 | 0.764 | 0.090 | 0.271 | 0.067 | 0.139 | 0.101 | 0.104 | 0.080 | 0.070 | 0.123 | 0.077 | -0.138 | 1.000 | -0.070 | 0.076 | 0.340 | 0.005 | -0.101 | -0.024 | 0.057 | 0.196 | -0.138 | -0.070 | 1.000 | -0.136 |
| LONGITUDE | 0.008 | 0.062 | 0.607 | 0.178 | 0.415 | 0.273 | 0.356 | 0.049 | 0.252 | 0.094 | 0.345 | 0.279 | 0.090 | 0.056 | -0.070 | 1.000 | 0.080 | 0.382 | -0.018 | 0.047 | -0.019 | 0.080 | 0.088 | 0.056 | 1.000 | -0.070 | -0.838 |
| MAINOFF | 1.000 | 0.179 | 0.077 | 0.057 | 0.104 | 0.092 | 0.090 | 0.067 | 0.063 | 0.113 | 0.069 | 0.072 | 0.110 | 0.468 | 0.076 | 0.080 | 1.000 | 0.268 | 0.097 | 0.161 | 0.055 | 0.073 | 0.099 | 0.468 | 0.080 | 0.076 | 0.141 |
| MDI_STATUS_DESC | 0.281 | 0.478 | 0.459 | 0.225 | 0.300 | 0.285 | 0.454 | 0.288 | 0.287 | 0.430 | 0.405 | 0.340 | 0.396 | 0.141 | 0.340 | 0.382 | 0.268 | 1.000 | 0.292 | 1.000 | 0.156 | 0.374 | 0.398 | 0.141 | 0.382 | 0.340 | 0.356 |
| OBJECTID | 0.019 | 0.152 | 0.168 | 0.107 | 0.030 | 0.029 | 0.058 | 0.104 | 0.035 | -0.048 | 0.066 | 0.051 | -0.048 | -0.002 | 0.005 | -0.018 | 0.097 | 0.292 | 1.000 | 0.135 | 0.035 | 0.075 | 0.043 | -0.002 | -0.018 | 0.005 | -0.002 |
| OFFNUM | 0.012 | 0.221 | 0.192 | 0.166 | 0.253 | 0.155 | 0.143 | 0.149 | 0.052 | -0.440 | 0.113 | 0.105 | -0.438 | 0.112 | -0.101 | 0.047 | 0.161 | 1.000 | 0.135 | 1.000 | -0.023 | 0.057 | -0.087 | 0.112 | 0.047 | -0.101 | -0.044 |
| SERVTYPE | 0.044 | 0.048 | 0.099 | 0.041 | -0.026 | -0.014 | 0.038 | 0.042 | -0.001 | 0.052 | 0.026 | -0.002 | 0.052 | 0.168 | -0.024 | -0.019 | 0.055 | 0.156 | 0.035 | -0.023 | 1.000 | 1.000 | 0.028 | 0.168 | -0.019 | -0.024 | 0.039 |
| SERVTYPE_DESC | 0.071 | 0.384 | 0.298 | 0.051 | 0.046 | 0.057 | 0.061 | 0.065 | 0.044 | 0.082 | 0.045 | 0.065 | 0.031 | 0.103 | 0.057 | 0.080 | 0.073 | 0.374 | 0.075 | 0.057 | 1.000 | 1.000 | 0.073 | 0.103 | 0.080 | 0.057 | 0.059 |
| STCNTY | -0.035 | 0.100 | 0.904 | 0.324 | 0.535 | 0.356 | 0.541 | 0.180 | 0.414 | 0.086 | 0.511 | 0.472 | 0.087 | -0.009 | 0.196 | 0.088 | 0.099 | 0.398 | 0.043 | -0.087 | 0.028 | 0.073 | 1.000 | -0.009 | 0.088 | 0.196 | -0.101 |
| UNINUM | 0.326 | 0.097 | 0.138 | 0.095 | 0.160 | 0.125 | 0.163 | 0.115 | 0.066 | 0.130 | 0.122 | 0.088 | 0.129 | 1.000 | -0.138 | 0.056 | 0.468 | 0.141 | -0.002 | 0.112 | 0.168 | 0.103 | -0.009 | 1.000 | 0.056 | -0.138 | -0.001 |
| X | 0.008 | 0.062 | 0.607 | 0.178 | 0.415 | 0.273 | 0.356 | 0.049 | 0.252 | 0.094 | 0.345 | 0.279 | 0.090 | 0.056 | -0.070 | 1.000 | 0.080 | 0.382 | -0.018 | 0.047 | -0.019 | 0.080 | 0.088 | 0.056 | 1.000 | -0.070 | -0.838 |
| Y | -0.117 | 0.058 | 0.764 | 0.090 | 0.271 | 0.067 | 0.139 | 0.101 | 0.104 | 0.080 | 0.070 | 0.123 | 0.077 | -0.138 | 1.000 | -0.070 | 0.076 | 0.340 | 0.005 | -0.101 | -0.024 | 0.057 | 0.196 | -0.138 | -0.070 | 1.000 | -0.136 |
| ZIP | 0.018 | 0.158 | 0.927 | 0.371 | -0.422 | -0.275 | 0.387 | 0.159 | -0.262 | -0.093 | 0.377 | -0.267 | -0.088 | -0.001 | -0.136 | -0.838 | 0.141 | 0.356 | -0.002 | -0.044 | 0.039 | 0.059 | -0.101 | -0.001 | -0.838 | -0.136 | 1.000 |
Missing values
Sample
| X | Y | OBJECTID | ACQDATE | ADDRESS | ADDRESS2 | BKCLASS | CBSA | CBSA_DIV | CBSA_DIV_FLG | CBSA_DIV_NO | CBSA_METRO | CBSA_METRO_FLG | CBSA_METRO_NAME | CBSA_MICRO_FLG | CBSA_NO | CERT | CITY | COUNTY | CSA | CSA_FLG | CSA_NO | ESTYMD | FI_UNINUM | ID | LATITUDE | LONGITUDE | MAINOFF | MDI_STATUS_CODE | MDI_STATUS_DESC | NAME | OFFNAME | OFFNUM | RUNDATE | SERVTYPE | SERVTYPE_DESC | STALP | STCNTY | STNAME | UNINUM | ZIP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | -89.554910 | 38.684286 | 1 | 42539.0 | 18001 Saint Rose Rd | NaN | SM | St. Louis, MO-IL | NaN | 0.0 | NaN | 41180.0 | 1.0 | St. Louis, MO-IL | 0.0 | 41180.0 | 14761.0 | Breese | Clinton | St. Louis-St. Charles-Farmington, MO-IL | 1.0 | 476.0 | 30964 | 9231.0 | 223055.0 | 38.684286 | -89.554910 | 0.0 | NaN | NaN | 1NB Bank | ST. ROSE FACILITY BRANCH | 3.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | IL | 17027.0 | Illinois | 223055.0 | 62230.0 |
| 1 | -89.372215 | 38.618182 | 2 | NaN | 1350 12th St | NaN | SM | St. Louis, MO-IL | NaN | 0.0 | NaN | 41180.0 | 1.0 | St. Louis, MO-IL | 0.0 | 41180.0 | 14761.0 | Carlyle | Clinton | St. Louis-St. Charles-Farmington, MO-IL | 1.0 | 476.0 | 25373 | 9231.0 | 232078.0 | 38.618182 | -89.372215 | 0.0 | NaN | NaN | 1NB Bank | 1350 12TH STREET FACILITY | 1.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | IL | 17027.0 | Illinois | 232078.0 | 62231.0 |
| 2 | -89.612338 | 38.611731 | 3 | NaN | 500 W Harrison St | NaN | SM | St. Louis, MO-IL | NaN | 0.0 | NaN | 41180.0 | 1.0 | St. Louis, MO-IL | 0.0 | 41180.0 | 14761.0 | Aviston | Clinton | St. Louis-St. Charles-Farmington, MO-IL | 1.0 | 476.0 | 39104 | 9231.0 | 466427.0 | 38.611731 | -89.612338 | 0.0 | NaN | NaN | 1NB Bank | AVISTON BRANCH | 2.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | IL | 17027.0 | Illinois | 466427.0 | 62216.0 |
| 3 | -89.369023 | 38.611248 | 4 | NaN | 891 Fairfax St | NaN | SM | St. Louis, MO-IL | NaN | 0.0 | NaN | 41180.0 | 1.0 | St. Louis, MO-IL | 0.0 | 41180.0 | 14761.0 | Carlyle | Clinton | St. Louis-St. Charles-Farmington, MO-IL | 1.0 | 476.0 | 01/01/1878 | 9231.0 | 9231.0 | 38.611248 | -89.369023 | 1.0 | NaN | NaN | 1NB Bank | 1NB Bank | 0.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | IL | 17027.0 | Illinois | 9231.0 | 62231.0 |
| 4 | -90.655980 | 38.797082 | 5 | NaN | 240 Salt Lick Rd | NaN | NM | St. Louis, MO-IL | NaN | 0.0 | NaN | 41180.0 | 1.0 | St. Louis, MO-IL | 0.0 | 41180.0 | 57899.0 | Saint Peters | St. Charles | St. Louis-St. Charles-Farmington, MO-IL | 1.0 | 476.0 | 38383 | 429739.0 | 429739.0 | 38.797082 | -90.655980 | 1.0 | NaN | NaN | 1st Advantage Bank | 1st Advantage Bank | 0.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | MO | 29183.0 | Missouri | 429739.0 | 63376.0 |
| 5 | -114.770516 | 32.489945 | 6 | 40960.0 | 645 N William Brooks Ave | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 57298.0 | San Luis | Yuma | NaN | 0.0 | 0.0 | 35216 | 360755.0 | 251437.0 | 32.489945 | -114.770516 | 0.0 | NaN | NaN | 1st Bank Yuma | SAN LUIS BRANCH | 4.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | AZ | 4027.0 | Arizona | 251437.0 | 85336.0 |
| 6 | -114.624469 | 32.676737 | 7 | NaN | 2799 S 4th Ave | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 57298.0 | Yuma | Yuma | NaN | 0.0 | 0.0 | 37138 | 360755.0 | 360755.0 | 32.676737 | -114.624469 | 1.0 | NaN | NaN | 1st Bank Yuma | 1st Bank Yuma | 0.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | AZ | 4027.0 | Arizona | 360755.0 | 85364.0 |
| 7 | -114.624789 | 32.694539 | 8 | 42251.0 | 1800 S 4th Ave | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 57298.0 | Yuma | Yuma | NaN | 0.0 | 0.0 | 39329 | 360755.0 | 467596.0 | 32.694539 | -114.624789 | 0.0 | NaN | NaN | 1st Bank Yuma | YUMA BRANCH | 5.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | AZ | 4027.0 | Arizona | 467596.0 | 85364.0 |
| 8 | -110.931017 | 31.347570 | 9 | 42223.0 | 825 N Grand Ave | Ste 104 | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 57298.0 | Nogales | Santa Cruz | NaN | 0.0 | 0.0 | 39352 | 360755.0 | 468263.0 | 31.347570 | -110.931017 | 0.0 | NaN | NaN | 1st Bank Yuma | NOGALES BRANCH | 6.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | AZ | 4023.0 | Arizona | 468263.0 | 85621.0 |
| 9 | -114.444178 | 32.660442 | 10 | NaN | 11600 S Fortuna Rd | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 57298.0 | Yuma | Yuma | NaN | 0.0 | 0.0 | 39790 | 360755.0 | 493457.0 | 32.660442 | -114.444178 | 0.0 | NaN | NaN | 1st Bank Yuma | Fortuna Branch | 3.0 | 45401.0 | 13.0 | FULL SERVICE - HOME BANKING | AZ | 4027.0 | Arizona | 493457.0 | 85367.0 |
| X | Y | OBJECTID | ACQDATE | ADDRESS | ADDRESS2 | BKCLASS | CBSA | CBSA_DIV | CBSA_DIV_FLG | CBSA_DIV_NO | CBSA_METRO | CBSA_METRO_FLG | CBSA_METRO_NAME | CBSA_MICRO_FLG | CBSA_NO | CERT | CITY | COUNTY | CSA | CSA_FLG | CSA_NO | ESTYMD | FI_UNINUM | ID | LATITUDE | LONGITUDE | MAINOFF | MDI_STATUS_CODE | MDI_STATUS_DESC | NAME | OFFNAME | OFFNUM | RUNDATE | SERVTYPE | SERVTYPE_DESC | STALP | STCNTY | STNAME | UNINUM | ZIP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79532 | 0.000000 | 0.000000 | 79533 | 43952.0 | 301 N Pine St | NaN | NM | DeRidder, LA | NaN | 0.0 | NaN | 0.0 | 0.0 | NaN | 1.0 | 19760.0 | 58228.0 | Deridder | Beauregard | DeRidder-Fort Polk South, LA | 1.0 | 217.0 | 05/28/1928 | 443550.0 | 6747.0 | 0.000000 | 0.000000 | 0.0 | NaN | NaN | b1BANK | Deridder Banking Cener Branch | 71.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | LA | 22011.0 | Louisiana | 6747.0 | 70634.0 |
| 79533 | 0.000000 | 0.000000 | 79534 | NaN | 1300 W Tunnel Blvd | NaN | NM | Houma-Thibodaux, LA | NaN | 0.0 | NaN | 26380.0 | 1.0 | Houma-Thibodaux, LA | 0.0 | 26380.0 | 58228.0 | Houma | Terrebonne | NaN | 0.0 | NaN | 05/01/2020 | 443550.0 | 73828.0 | 0.000000 | 0.000000 | 0.0 | NaN | NaN | b1BANK | Houma - W Tunnel Blvd Banking Center Branch | 79.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | LA | 22109.0 | Louisiana | 73828.0 | 70360.0 |
| 79534 | -116.792632 | 47.681198 | 79535 | NaN | 912 Northwest Blvd | NaN | NM | Coeur d'Alene, ID | NaN | 0.0 | NaN | 17660.0 | 1.0 | Coeur d'Alene, ID | 0.0 | 17660.0 | 57074.0 | Coeur D Alene | Kootenai | Spokane-Spokane Valley-Coeur d'Alene, WA-ID | 1.0 | 518.0 | 05/17/2001 | 356862.0 | 356862.0 | 47.681198 | -116.792632 | 1.0 | NaN | NaN | bankcda | bankcda | 0.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | ID | 16055.0 | Idaho | 356862.0 | 83814.0 |
| 79535 | -116.124442 | 47.537693 | 79536 | 41509.0 | 120 Railroad Ave | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 57074.0 | Kellogg | Shoshone | NaN | 0.0 | 0.0 | 09/18/2000 | 356862.0 | 360910.0 | 47.537693 | -116.124442 | 0.0 | NaN | NaN | bankcda | Kellogg Branch | 4.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | ID | 16079.0 | Idaho | 360910.0 | 83837.0 |
| 79536 | -116.788501 | 47.758750 | 79537 | NaN | 162 W Hayden Ave | NaN | NM | Coeur d'Alene, ID | NaN | 0.0 | NaN | 17660.0 | 1.0 | Coeur d'Alene, ID | 0.0 | 17660.0 | 57074.0 | Hayden | Kootenai | Spokane-Spokane Valley-Coeur d'Alene, WA-ID | 1.0 | 518.0 | 04/13/2015 | 356862.0 | 567663.0 | 47.758750 | -116.788501 | 0.0 | NaN | NaN | bankcda | Hayden Branch | 5.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | ID | 16055.0 | Idaho | 567663.0 | 83835.0 |
| 79537 | -116.935850 | 47.714039 | 79538 | NaN | 922 E Polston Ave | NaN | NM | Coeur d'Alene, ID | NaN | 0.0 | NaN | 17660.0 | 1.0 | Coeur d'Alene, ID | 0.0 | 17660.0 | 57074.0 | Post Falls | Kootenai | Spokane-Spokane Valley-Coeur d'Alene, WA-ID | 1.0 | 518.0 | 09/10/2019 | 356862.0 | 616993.0 | 47.714039 | -116.935850 | 0.0 | NaN | NaN | bankcda | Post Falls Branch | 6.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | ID | 16055.0 | Idaho | 616993.0 | 83854.0 |
| 79538 | 0.000000 | 0.000000 | 79539 | NaN | 120 Railroad Ave | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 57074.0 | Kellogg | Shoshone | NaN | 0.0 | 0.0 | 03/21/2022 | 356862.0 | 651678.0 | 0.000000 | 0.000000 | 0.0 | NaN | NaN | bankcda | Messenger Service Branch | 7.0 | 45401.0 | 27.0 | LIMITED SERVICE - MESSENGER | ID | 16079.0 | Idaho | 651678.0 | 83837.0 |
| 79539 | -92.952975 | 40.266955 | 79540 | NaN | 1 S Lincoln St | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 16103.0 | Green City | Sullivan | NaN | 0.0 | 0.0 | 11/21/1943 | 10320.0 | 10320.0 | 40.266955 | -92.952975 | 1.0 | NaN | NaN | farmbank | farmbank | 0.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | MO | 29211.0 | Missouri | 10320.0 | 63545.0 |
| 79540 | 0.000000 | 0.000000 | 79541 | NaN | 701 N Pearl St | NaN | NM | NaN | NaN | 0.0 | 0.0 | 0.0 | 0.0 | NaN | 0.0 | 0.0 | 16103.0 | Milan | Sullivan | NaN | 0.0 | 0.0 | 09/17/2007 | 10320.0 | 468331.0 | 0.000000 | 0.000000 | 0.0 | NaN | NaN | farmbank | Milan Branch | 2.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | MO | 29211.0 | Missouri | 468331.0 | 63556.0 |
| 79541 | -92.583356 | 40.228715 | 79542 | NaN | 3311 N Baltimore St | NaN | NM | Kirksville, MO | NaN | 0.0 | NaN | 0.0 | 0.0 | NaN | 1.0 | 28860.0 | 16103.0 | Kirksville | Adair | NaN | 0.0 | NaN | 12/16/2020 | 10320.0 | 629595.0 | 40.228715 | -92.583356 | 0.0 | NaN | NaN | farmbank | Kirksville Branch | 3.0 | 45401.0 | 11.0 | FULL SERVICE - BRICK AND MORTAR | MO | 29001.0 | Missouri | 629595.0 | 63501.0 |